mysql> use mysql; mysql> update user set grant_priv = 'Y' where user = 'root'; mysql> flush privileges
and reconnect to mysql server as root user and retry grant clause. You'll be happy!!! ^^ > Greetings, > > I'm trying to create a database and then adding a > specialized user so it can work with it, but so far i > got no luck: > > [EMAIL PROTECTED] josevnz]$ mysql -u root -p -h > localhost.localdomain > Enter password: > Welcome to the MySQL monitor. Commands end with ; or > \g. > Your MySQL connection id is 11 to server version: > 4.0.12 > > Type 'help;' or '\h' for help. Type '\c' to clear the > buffer. > > mysql> use mysql; > Database changed > mysql> CREATE DATABASE test_cvebrowser; > Query OK, 1 row affected (0.00 sec) > > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP > ON test_cvebrowser.* TO > 'test_cvebrowser_user'@'localhost.localdomain' > IDENTIFIED BY 'cv3br0ws3r'; > ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' > to database 'test_cvebrowser' > mysql> > > Any ideas what's wrong? (must be something pretty > simple, but no cigar so far). I don't understand why > the error if i managed to connect the first time. > > I'm using: > - Redhat Linux 8.0 > - MySQL 4.0.12 (fresh install) > > PD: I already checked the documentation at > 'http://www.mysql.com/doc/en/Database_use.html', but > no luck. > > Thanks in advance, > > JV. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
