Create MySQL Users?

[jasonlambert]

Hi.

I have a MySQL server running, but do not have PHPMyAdmin installed (and want to keep it like that for the mean time).

Within MySQL, i have a database named "backenddb".

I access MySQL using the Linux Comand Line mysql utility.

How do i add a mysql user the ability to login and work within the backenddb database only? - using the command line utility?

Cheers,

Jason

[flw]

Followup question is doesn't cron run as root? If so then you can run a script via cron or am I nuts or is it a bananna?

[e_dreamer]

This would add the user 'newuser' with the password 'thepassword' and then give the user access to backenddb from any host with privelages to select, insert, update, delete, create and drop. Its not amazingly hard to userstand the bulk of it. So you'll be able to change anything you want or don't want quite easily.

This will need to be done as the root mysql user.

mysql> use mysql;
mysql> insert into 
         -> user (host, user, password)
         -> values('%','newuser',password('thepassword'));
mysql> insert into
      -> db (host,db,user,Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv)
      -> values ('%','backenddb','newuser','Y','Y','Y','Y','Y','Y');
mysql> quit

Ive never used the linux mysql util, but I am familer with mysql, and it all looks right from what I've learnt.

hope thats what you ment.

[jasonlambert]

yes that is what i ment, only problem is i cannot login with my newly created user, even if i specify the username, password, and the database to use as command line switches.

transcript of session:

root@london:/data/web/this_site_does_not_exist# mysql -u phpbb -p --database=backenddb
Enter password:
ERROR 1045: Access denied for user: 'phpbb@localhost' (Using password: YES)
root@london:/data/web/this_site_does_not_exist#

any ideas?

[flw]

Checkout http://www.experts-exchange.com/Data..._10516859.html threads may help or not. Just a idea.

[notez]

Hi.

I have a MySQL server running, but do not have PHPMyAdmin installed (and want to keep it like that for the mean time).

Within MySQL, i have a database named "backenddb".

I access MySQL using the Linux Comand Line mysql utility.

How do i add a mysql user the ability to login and work within the backenddb database only? - using the command line utility?

Cheers,

Jason

mysql> grant all privileges on backenddb.* to newuser@localhost identified by 'password' ;