LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-02-2003, 07:29 AM   #1
jriis
Member
 
Registered: May 2001
Distribution: Debian, Foresight
Posts: 72

Rep: Reputation: 15
Unhappy 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.
 
Old 10-02-2003, 09:45 AM   #2
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
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
 
Old 10-02-2003, 10:13 AM   #3
jriis
Member
 
Registered: May 2001
Distribution: Debian, Foresight
Posts: 72

Original Poster
Rep: Reputation: 15
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
 
Old 10-02-2003, 10:20 AM   #4
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
Code:
GRANT ALL on * to user@'%' indentified by 'users_password';
indentified?

I hate typing too
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Grant Privileges - MySQL Jannyno Linux - General 2 06-23-2012 03:00 AM
mySQL - local user privileges Genjix Programming 2 12-03-2004 09:03 AM
Mysql privileges question everythingand2 Linux - General 0 12-14-2003 03:29 PM
New Table Privileges in MySQL chrisk5527 Linux - General 0 11-19-2003 05:22 PM
Lost privileges for MySQL !!! davidgordon Linux - Newbie 2 01-09-2003 08:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:49 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration