how to create a user that has access priv to mysql in rh 9.0?

spyghost · 11-01-2003, 08:08 AM

hi,

i am creating a simple web based database with mysql, php, and apache in rh 9.0.

i use this inside the php script that i am making:
$connection = mysql_connect("localhost", "root", "mypasswd");

i would like to create another user that has access priviledges to mysql because its not good to user root right?

i tried to make one user a member of the mysql group and here is what happened... the user can "connect" to mysql, but he cannot select a database...
mysql_select_db("database", $connection);

now, how do i add the user "properly" such that he can do everything in mysql (without considering root of course)

thanks...

david_ross · 11-01-2003, 09:16 AM

If you want to do it graphically hten phpMyAdmin is great. On the cli - try:
mysql -u root
(enter your password)

Then at the mysql prompt:
grant all on DATABASE.* to SOMEUSER@localhost identified by 'PASSWORD';

You'll need to replace the words in capitals obviously. This gives which ever user you choose full access to that one database - if you want to set more restricive permissions then look at the mysql docs on the GRANT statement.

spyghost · 11-01-2003, 09:40 AM

Quote:

Originally posted by david_ross
If you want to do it graphically hten phpMyAdmin is great. On the cli - try:
mysql -u root
(enter your password)

Then at the mysql prompt:
grant all on DATABASE.* to SOMEUSER@localhost identified by 'PASSWORD';

You'll need to replace the words in capitals obviously. This gives which ever user you choose full access to that one database - if you want to set more restricive permissions then look at the mysql docs on the GRANT statement.

is that a downloadable software? where can i download it?

david_ross · 11-01-2003, 09:45 AM

phpMyAdmin? here:
http://www.phpmyadmin.net/home_page/

spyghost · 11-02-2003, 03:15 AM

thanks!