Re: Access denied for user - new setup issue

[Julian Davtchev]

MYSQL MANUAL:
1----------------------------------------------------------------------------
...
First, use the mysql program to connect to the server as the MySQL root user:

shell> mysql -u root mysql


If you have assigned a password to the root account, you'll also need to supply a --password or -p option for this mysql command and also for those later in this section.


After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
...
1----------------------------------------------------------------------------
The problem is the user you're using probably have no grant privileges. You can check the user you're logged in as:
SELECT CURRENT_USER(); -> the user recongnized by the grant tables
2---------------------------------------------------------------------------
e.g.
mysql> SELECT USER();
+--------------------+
| USER() |
+--------------------+
| testuser@localhost |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT CURRENT_USER();
+----------------+
| CURRENT_USER() |
+----------------+
| @localhost |
+----------------+
1 row in set (0.00 sec)

mysql> SHOW GRANTS FOR ''@localhost; //check if you have grant option over mysql database.


2-------------------------------------------------------------------------

SELECT USER(); -> the user you typed in when connecting (e.g mysql -u testuser)
You could check the current users defined with:
SELECT user,host FROM mysql.user;

Hope I've helped.