MySQL 5.1 with Maria Reference Manual :: B Errors, Error Codes, and Common Problems :: B.1 Problems and Common Errors :: B.1.2 Common Errors When Using MySQL Programs :: B.1.2.1 Access denied
Section Navigation [Toggle]
- B.1.2 Common Errors When Using MySQL Programs
- B.1.2.1 Access denied
- B.1.2.2 Can't connect to [local] MySQL server
- B.1.2.3 Lost connection to MySQL server
- B.1.2.4 Client does not support authentication protocol
- B.1.2.5 Password Fails When Entered Interactively
- B.1.2.6 Host 'host_name' is blocked
- B.1.2.7 Too many connections
- B.1.2.8 Out of memory
- B.1.2.9 MySQL server has gone away
- B.1.2.10 Packet too large
- B.1.2.11 Communication Errors and Aborted Connections
- B.1.2.12 The table is full
- B.1.2.13 Can't create/write to file
- B.1.2.14 Commands out of sync
- B.1.2.15 Ignoring user
- B.1.2.16 Table 'tbl_name' doesn't exist
- B.1.2.17 Can't initialize character set
- B.1.2.18 'File' Not Found and Similar Errors
- B.1.2.19 Table-Corruption Issues
An Access denied error can have many
causes. Often the problem is related to the MySQL accounts
that the server allows client programs to use when connecting.
See Section 5.4, “The MySQL Access Privilege System”, and
Section 5.4.7, “Causes of Access-Denied Errors”.
User Comments
I had this problem and discovered that the user's password became corrupted, using the root account I did an update and reset the user password to a know value.
Maybe obvious to some but
You need to connect to a database before anything will work. If you get errors like 'access denied xxx@localhost' it may be because you have not connected to a database yet.
Even though the service is running you can't do anything without first connecting to a database.
One way to do this, is open the 'MySQL Command line client' installed in Windows when you run the 'mysql-4.1.13-win32.zip' file
Click Start button then 'Programs' , 'MySQL', 'MySQL Server 4.1', 'MySQL Command line client'
If it asks for a password key it in, hopefully you remembered it when you installed the MySQL. If not rerun the wizard by clicking Start button,
'MySQL', 'MySQL Server 4.1', 'MySQL Server instance config wizard'
At the prompt MySQL> key in this
connect yourdatabasename
Such as
connect test
test is a sample database installed for you. It has no tables though. You can create a table by keying in this at the prompt
Create Table sample (ID int, FName char(20), LName char(20)); <<< don't forget the semicolon
Then add data to the sample table key this in at the prompt
Insert Into sample (ID, FName, LName) values (1, 'fred', 'flintstone');
If you don't put a semicolon at the end of a SQL line you will get a new -> each time you hit the Enter key.
PHP520, MYSQL5027, WinServer2003r2
i created a database with no tables
i created a user with no privileges (testuser,testpw,localhost)
<?php$MYhostname="localhost"; $MYusername="testuser"; $MYpassword="testpw"; $MYdatabase="mysqlitest";
$MYlink=mysqli_connect($MYhostname, $MYusername, $MYpassword, $MYdatabase) or trigger_error(mysqli_connect_error(),E_USER_ERROR);
printf("Host information: %s\n", mysqli_get_host_info($MYlink));
mysqli_close($MYlink);
?>
This gave an Access Denied error.
But it works with mysql_connect() !!!!!!!!!!!!!
Solution: give the user a GLOBAL SELECT privilege
or create a table and give a SELECT priviledge to the table.
Hope this helps.
Add your own comment.