roasthawg

Anyone have step-by-step instructions on how to get Excel to open mysql databases in uniformserver? I've tried to download the odbc drivers but no luck on getting it to work.

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

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)

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!