roasthawg Posted November 1, 2010 Report Share Posted November 1, 2010 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! Quote Link to comment Share on other sites More sharing options...
Ric Posted November 2, 2010 Report Share Posted November 2, 2010 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 bestRic Quote Link to comment Share on other sites More sharing options...
roasthawg Posted November 2, 2010 Author Report Share Posted November 2, 2010 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) Quote Link to comment Share on other sites More sharing options...
Ric Posted November 2, 2010 Report Share Posted November 2, 2010 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? Quote Link to comment Share on other sites More sharing options...
roasthawg Posted November 2, 2010 Author Report Share Posted November 2, 2010 Great, that fixed it! Thanks a lot for your help... I thought the password was blank after looking in phpmyadmin but was obviously mistaken! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.