LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MySQL problem with user privileges (https://www.linuxquestions.org/questions/linux-software-2/mysql-problem-with-user-privileges-99353/)

jriis 10-02-2003 06:29 AM

MySQL problem with user privileges
 
Hi

I have just installed Mandrake 9.1 and was eager to use mysql. I have no problem logging onto mysql and is able to use the database test, but here the fun stops. My user cannot create databases. How do I grant access to my user? What should I change in the table user in the database mysql and how do I do it ?

Thanks

Jan Riis Soerensen, Denmark
Happy Mandraker.

Looking_Lost 10-02-2003 08:45 AM

Which user? The mysql root user or a user you created?

Generally you do as root

use mysql;

GRANT ALL on * to bigmadjimmy@'%' identified by 'some_password_or_other';

flush privileges;

Which would let the user bigmadjimmy connect from anywhere with full rights to do anthing they please

if you just want to allow bigmadjimmy to create databases and tables accessing from anywhere

GRANT CREATE on * to bigmadjimmy@'%' identified by 'some_password_or_other';

There's a good few combinations of privileges/access permissions you can assign to a user

jriis 10-02-2003 09:13 AM

MySQL problem with user privileges
 
Hi

thanks for your reply, but I am still having problems, see below:



mysql> GRANT ALL on * to user@'%' indentified by 'users_password';

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'indentified by 'users_password' at line 1


What now ?

Thanks

Jan

Looking_Lost 10-02-2003 09:20 AM

Code:

GRANT ALL on * to user@'%' indentified by 'users_password';
indentified?

I hate typing too :)


All times are GMT -5. The time now is 08:22 AM.