LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-29-2003, 08:07 PM   #1
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Rep: Reputation: 15
mysql grant issues


hello everybody,

mysql issue on linux redhat 9..---->cant create tables in mysql

as a root user i created a database and granted a user access to it to create tables..
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON test2db.* TO test2db@localhost IDENTIFIED BY 'test2dbpwd2';
Query OK, 0 rows affected (0.08 sec)

then i logged in as the user "test2db"
mysql> use test2db
Database changed

mysql> status
--------------
mysql Ver 11.18 Distrib 3.23.54, for redhat-linux-gnu (i386)

Connection id: 8
Current database: test2db
Current user: test2db@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.54

** tried creating a table using the following command but for some reason its not creating the table....
mysql> create table test_table (f_name varchar(20), l_name varchar(20), age int);
ERROR 1044: Access denied for user: 'test2db@localhost' to database 'test2db'
mysql>
am i missing something here?
i should also add that, i'm able to create the tables as a root user...

Last edited by Robin01; 10-29-2003 at 08:10 PM.
 
Old 10-29-2003, 09:56 PM   #2
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 416Reputation: 416Reputation: 416Reputation: 416Reputation: 416
Quote:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON test2db.* TO test2db@localhost IDENTIFIED BY 'test2dbpwd2'

Note the list of privileges you granted: Select, Insert, Update and Delete. Note that none of these are CREATE. So basically, the database is behaving perfectly. You just need to grant yourself a few more permissions.
 
  


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 02:00 AM
Why mysql GRANT does not work? robertoneto123 Linux - Software 2 01-23-2004 07:33 AM
Updating MySQL grant tables... sigep739 Linux - Newbie 2 01-03-2004 11:57 PM
MYSQL GRANT etc etc markopolox Programming 8 09-23-2003 02:58 AM
Mysql User grant problems ubers0ldat Linux - Software 7 07-30-2003 12:33 AM


All times are GMT -5. The time now is 04:17 AM.

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