Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 10-29-2003, 09:07 PM   #1
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'
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 09:10 PM.
Old 10-29-2003, 10:56 PM   #2
LQ Veteran
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 420Reputation: 420Reputation: 420Reputation: 420Reputation: 420
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.


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

All times are GMT -5. The time now is 01:35 AM.

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