Need someone to help me with MySQL real quick please :(

[DannyBoy]

Please please please

Im really stuck with a "GRANT" quiery in SQL

Im using phpMyAdmin and need someones help just for this 1 line of code i need to get right

Someone please help *Crys*

Thanks
Dan

Edit: My MSN account is: somefitbloke@hotmail.com - Please reply to this thread first if you think you can help then add me

Thanks again

 

[WannaFly]

It would be a good idea to post it here so we can see what problem your having...Also is incase other people have that problem too.

 

[DannyBoy]

Originally posted by: WannaFly
It would be a good idea to post it here so we can see what problem your having...Also is incase other people have that problem too.

Genius - You had me thinking someone had offered help

Im trying to create a supposed user in my db.

Basically this is the only instruction I have been given and as always with SQL instructions, its not exactly detailed.

* Create a Database USER.

$ mysql (My db name)
mysql > grant usage on (My db name).* to dbuser@localhost;
mysql > grant select,insert,delete,update on postaci.* to dbuser@localhost;
mysql > exit;
$ mysqladmin -u dbuser password "new password"

* make sure the password is the same as "new password" in the includes/global.inc file.

(Remembering that the My db name in brackets is just my database name)

Ok only thing is im running phpmyadmin. Now in phpmyadmin, it shouldnt be any different, I can still execute the same SQL commands from phpmyadmin right?

Everytime I try and execute the first part of the above command (grant usage on (My db name).* to dbuser@localhost[img]i/expressions/face-icon-small-wink.gif[/img] I get an access denied error

Am I doing this wrong? Im not entirely sure what im supposed to be putting?!

Any ideas?

 

[eklass]

USE mysql;
INSERT INTO user ('localhost', 'theusername', PASSWORD('thepassword'));
INSERT INTO db('%', 'thedatabase', 'theusername', 'Y', 'Y', 'Y', 'Y');
FLUSH PRIVILEGES;




i think that's how you'd do it manually. i always just use phpmyadmin to insert the appropriate entries and reload mysql

 

[DannyBoy]

Yeah you see the thing is my database is hosted with my host (Oneandone)

Thats why am using phpmyadmin, because I cannot physically get to the machine, its locked away in some "Safe to nuclear standards" datacentre with 5 billion alarms, a pressure sensitive floor, laser's n all.

Anyway that went a bit OT, but ill try that and see what it will do.

What does flushing tables actually do? Will I lose any data in the database? I have a lot of stuff in other table you see.

Dan

 

[Nothinman]

If you can connect to MySQL via the Internet you can use the mysql command-line tool from any machine.

 

[kt]

Do you own the MySQL server? Or is it a shared one? If the latter, I don't think you are given the privileges to add a new user to the database.

 

[eklass]

oh.. if it's on a host in which you don't have that kind of control, thn you simply need to ask your provider to add the user

 

[Armitage]

if you're getting access denied, you simply don't havethe proper privileges. You need to be logged into MySQL as root or some other privileged user.

 

[DannyBoy]

Originally posted by: ergeorge
if you're getting access denied, you simply don't havethe proper privileges. You need to be logged into MySQL as root or some other privileged user.

The MySQL database is soley mine, through my hosting company.

I have full admin rights of my database - or so I thought

I dont know what the problem is at all

 

[awal]

Originally posted by: Nothinman
If you can connect to MySQL via the Internet you can use the mysql command-line tool from any machine.

this statement is incorrect...

 

[Nothinman]

this statement is incorrect...

Partially, it depends on how the host is setup.

 

[awal]

Originally posted by: Nothinman

this statement is incorrect...

Partially, it depends on how the host is setup.

agreed... no reliable host should put their sql servers on the internet...

 

[Nothinman]

But as we saw from slammer or whatever it was called, not everyone feels that way.

 

[DannyBoy]

Originally posted by: adrianwalters

Originally posted by: Nothinman

this statement is incorrect...

Partially, it depends on how the host is setup.

agreed... no reliable host should put their sql servers on the internet...

The SQL server is not on the internet

 

[kt]

Originally posted by: DannyBoy

Originally posted by: ergeorge
if you're getting access denied, you simply don't havethe proper privileges. You need to be logged into MySQL as root or some other privileged user.

The MySQL database is soley mine, through my hosting company.

I have full admin rights of my database - or so I thought

I dont know what the problem is at all

Let me get this right. Are you the SOLE owner (whether it is leasing/renting) of the machine running the MySQL server? If that's the case, how much are you paying monthly? There's a difference between having full admin rights to your database and full admin rights to the MySQL server.

 

[spyordie007]

What does flushing tables actually do? Will I lose any data in the database? I have a lot of stuff in other table you see.

Actually he said flush privilages but in either case it's pretty much the same. You dont loose the data but it causes it to "reload" the data, since the users are basically another database on the server it has to flush the privilages from the db (load the new data into memory) before those settings take effect.

So if after creating a new user and giving them privilages you are getting permission errors (and you are sure you entered everything correct) it probably means that privilages didnt get flushed.

BTW if you have access to administrate it with PHPMyAdmin why dont you just create users and setup their privilages from there?

-Spy

 

[DannyBoy]

Originally posted by: kt

Originally posted by: DannyBoy

Originally posted by: ergeorge
if you're getting access denied, you simply don't havethe proper privileges. You need to be logged into MySQL as root or some other privileged user.

The MySQL database is soley mine, through my hosting company.

I have full admin rights of my database - or so I thought

I dont know what the problem is at all

Let me get this right. Are you the SOLE owner (whether it is leasing/renting) of the machine running the MySQL server? If that's the case, how much are you paying monthly? There's a difference between having full admin rights to your database and full admin rights to the MySQL server.

Oops, my bad

Im the sole owner of the db


Update though, ive sorted the problem and have everything working now

Thanks for your help guys

Dan

 

[Armitage]

So what was the problem??

 

[DannyBoy]

Originally posted by: ergeorge
So what was the problem??

Instead of logging on with a user account, I didnt realise that the webmail script I configured was authenticating directly from the mail servers accounts.

For instance I was trying to logon with username dan and my password.

What the script was wanting was the e-mail address and pw of the mailbox account on the pop3 server.

You get that

You can checkout the webmail interface when ive finished it