 |  |  |  |  |  |  |  |
#1045 - Access denied for user 'root'@'localhost'
 |
Hi,
I get this error in my myPhpAdmin in WAMPserver 2f.
How can i solve it?
I get this error in my myPhpAdmin in WAMPserver 2f.
MySQL Syntax (Toggle Plain Text)
How can i solve it?
You aren't using a password for the root account and your access is denied, this certainly means that the root account on localhost does have a password.
Initially the root accounts created by the install script in MySQL do have an empty password, but as mentioned above your server does seem to have one.
Initially the root accounts created by the install script in MySQL do have an empty password, but as mentioned above your server does seem to have one.
Get up every morning and take a look at the Forbes' list of richest people. If your name doesn't appear.... GET TO WORK !!!
Detail your problem, where are you able to connect to the database from. Where is your phpMyAdmin located.
It would help you to know that user accounts in MySQL are made up of a username and a host that the username is allowed to connect from. So the account name is 'username@host'. An account john@mydomain may be able to connect to the MySQL server does not mean that the account john@domain2 would be able to connect to the same MySQL server too. This is what allows two persons with the same username but on a different machine to be identified as two different user accounts in MySQL and hence be controlled differently.
So when you say, you are able to connect to the server from, say, your PC does not mean that you should be able to connect from phpMyAdmin as well, cause, the phpMyAdmin module could be located on a different server.
It would help you to know that user accounts in MySQL are made up of a username and a host that the username is allowed to connect from. So the account name is 'username@host'. An account john@mydomain may be able to connect to the MySQL server does not mean that the account john@domain2 would be able to connect to the same MySQL server too. This is what allows two persons with the same username but on a different machine to be identified as two different user accounts in MySQL and hence be controlled differently.
So when you say, you are able to connect to the server from, say, your PC does not mean that you should be able to connect from phpMyAdmin as well, cause, the phpMyAdmin module could be located on a different server.
Last edited by verruckt24; Feb 17th, 2009 at 6:06 am.
Get up every morning and take a look at the Forbes' list of richest people. If your name doesn't appear.... GET TO WORK !!!
MySQL user permissions can be very very confusing, for the reasons that verruckt24 mentioned. Just because you've set permissions for a user one way doesn't mean he/she will be able to connect another way.
Have you tried using the system root password to log in to phpMyAdmin? Is this server yours, or are you using a hosting service?
Have you tried using the system root password to log in to phpMyAdmin? Is this server yours, or are you using a hosting service?
WolfWorkz Studios - Server Development
WolfWorkz.com
Pirates Registration
My Personal Blog
SideBySideGeek.com - My Newest Project
WolfWorkz.com
Pirates Registration
My Personal Blog
SideBySideGeek.com - My Newest Project
|
Similar Threads
- mysql denying access to all users except root (MySQL)
- mysql error (MySQL)
- phpMyAdmin access denied error on Win server 2003 - Mysql & PHP. Tried everything (PHP)
- phpmyadmin issue (PHP)
- Problems connecting to MySQL (IT Professionals' Lounge)
- MySql Labyrinth (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: Mysql remote access with phpmyadmin
- Next Thread: New to MySQL and lost already..
Views: 3630 | Replies: 4
| Thread Tools | Search this Thread |
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MySQL
"use" .db 1 ajax alphabet amazon aws camparingtocolumns cascade cast changingprices convert count count(col) data database delete design distinct ec2 eliminate enter error form generator html images innerjoins insert join keyword keywords matchingcolumns multiple multipletables mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch noob number open operand oracle order pdf php priceupdating print query recursive relationaldatabases relationship relationships remove reorderingcolumns resultset retrieve search select simpledb sort sql statement syntax table tree type-conversion update welsh
