Jump to content
The Uniform Server Community

Not welcome to phpMyAdmin...


bavel
 Share

Recommended Posts

When I try to access phpMyAdmin from the administrator screen, I do not get a chance to enter a username and password - instead I get an error message:

MySQL said: "#1045 - Access denied for user: 'root@localhost' (Using password: YES)"

 

Exactly where can I change the password to re-enable the login?

Link to comment
Share on other sites

The server is not running and that is why you get that message. The MySQL server is not running.

 

You do not need to chnage the password because it automatically uses the admin password.

 

Start the MySQL server and it should work. If you are still intrested in changing the password, edit the mysql_password file. Chnage the value to the password you want and that will be the new root password for MySQL.

Link to comment
Share on other sites

  • 1 month later...
I get an error message:

MySQL said: "#1045 - Access denied for user: 'root@localhost' (Using password: YES)"

i have this exact same problem as well. i clicked on "run MySQL Server" first then clicked on "PhpMyAdmin" and it still gives me this error.

 

but when i try to stop the MySQL server, it says that the server was not running so that means it was never running at the start even though i clicked on "run MySQL Server"?

 

what is going on here? is there anything else i forgot to install? because i just download uniserver 3.2 and ran it, nothing else.

 

i really need some help to get PhpMyAdmin running, its for an assignment i have to do B)

 

thanks in advance guys.

Link to comment
Share on other sites

Did u chnage the phpMyAdmin password or the MySQL root password by any chance?

 

Or are u using a new downloaded copy of phpMyAdmin and is MySQL installed on your computer 2ce?

Link to comment
Share on other sites

Did u chnage the phpMyAdmin password or the MySQL root password by any chance?

 

Or are u using a new downloaded copy of phpMyAdmin and is MySQL installed on your computer 2ce?

nah, i havent changed any passwords.

 

my copy of phpMyAdmin is old, its the version that came with Uniserver 3.2 i think. i will download the latest version and see how it goes.

 

what MySQL? Uniserver you mean? as i mentioned in my previous post, i only installed "Uniserver 3.2" and nothing else.

Link to comment
Share on other sites

  • 1 month later...
No problem, but i am still confused as to why the phpMyAdmin that came with the server did not work for you..

799[/snapback]

 

Yeah, it happend to me too.

 

I was on Uniformserver3.0 with NO root password, so my 12 databases (32Mo) in diskw\usr\local\mysql\data were configured to work with root/"" (no password).

So when I installed Uniformserver3.2a, all my databases didn't work anymore.

 

Ok, ok, I hear you, "just add it in your config", right but I have 147Mo in my /www folder ! (31 projects) so noway to change it.

 

So, smart as I am, I changed privileges settings for root to "NO password",

Then messed up with phpmyadmin (which log as root with password "root" (root/root)) and get the error message above in the first post.

 

Finally, I red your post and found where the password was in : \diskw\home\admin\WWW\mysql_password

 

so first I changed the root password in privileges to No password THEN deleted "root" in mysql_password and save and it works fine (it logs without password like old versions).

 

Something I'd like to add :

I use uniformserver since version 2.something.

When you have various project (like I do) in /www, the easiest way to upgrade is to replace every old folders by new ones except /mysql/data/"data_projects" folders and diskw/www, but it's a little bit tricky if some other stuff changes too.

May be if mysql data folders could be rerouted to somewhere else ?? outside /usr ??

 

Good luck and thanks for this great tool!

 

Phil

Link to comment
Share on other sites

  • 1 month later...

Erm... I got the same error.

 

With phpMyAdmin 2.6.0-beta2:

 

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

 

With phpMyAdmin 2.6.3-pl1:

 

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

 

With phpMyAdmin 2.6.3-rc1:

 

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

 

 

It was working perfectly before I upgraded Uniform...

Link to comment
Share on other sites

Is the /home/admin/WWW/mysql_password file still there?

 

If it isn't, create a file anmed mysql_password, no extension and enter root as the password. :(

 

Hope this helps...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...