Jump to content
The Uniform Server Community
Sign in to follow this  
roasthawg

phpmyadmin password change causing havoc

Recommended Posts

So I switched over from xampp to the uniform server because I was having problems with xampp running a few of my scripts. The switch was successful in that the uniform server runs those problem scripts with no problem. My issue is that I'm trying to convert all of my local stuff over to tus and some of it uses mysql databases. I was able to import my databases via phpmyadmin no problem but when I try to run my scripts I can't because of a password issue with the user root. If I go to phpmyadmin and change user root's pw to "no password" in the "privileges" tab the problem is solved and the scripts sends data to mysql... but a larger problem is created. I can no longer access phpmyadmin and even worse the uniform server crashes my computer whenever I try to "stop apache mysql".

 

Any help would be greatly appreciated... thanks!

Share this post


Link to post
Share on other sites

What version of US are you using?

 

“when I try to run my scripts I can't because of a password issue with the user root.”

Can you be more specific, any error messages, what do the log files show?

 

“If I go to phpmyadmin and change user root's pw to "no password" in the "privileges" tab the problem is solved and the scripts sends data to mysql... but a larger problem is created. I can no longer access phpmyadmin and even worse the uniform server crashes my computer whenever I try to "stop apache mysql".”

 

You never have to change the MySQL root user using phpmyadmin, only change allowed is the root password and this is performed using Apanel.

Changing the root user from phpmyadmin will result in issues you have experienced.

 

To solve your issues extract a fresh copy of US, install your scripts and note any errors produced. Post these along with any other information that may help us diagnose the problem.

 

All the best

Ric :)

Share this post


Link to post
Share on other sites

Here's the error:

 

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in C:\UniServer\www\simplehtmldom\basketballscraper.php on line 35 Could not connect: Access denied for user 'root'@'localhost' (using password: NO)

Share this post


Link to post
Share on other sites

Looks like a script problem!

"using password: NO" Indicates, no password is being specified by your script however to connect to MySQL server user root requires password root.

 

Can you post part of the script that connects to the MySQL server?

Share this post


Link to post
Share on other sites

Great, that fixed it! Thanks a lot for your help... I thought the password was blank after looking in phpmyadmin but was obviously mistaken!

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...
Sign in to follow this  

×
×
  • Create New...