Jump to content
The Uniform Server Community
bavel

Not welcome to phpMyAdmin...

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?

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
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?

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

got it working B)

 

installed the latest version of phpMyAdmin, version 2.6.2 and it worked.

 

thanks for the help olajideolaolorun :D

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

We will work on an upgrade tool or installer :( but about the mysql data, sorry... thats the best place... and it fits :D so things don't get messy

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
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...

Share this post


Link to post
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...

×
×
  • Create New...