Can't connect to MySQL server on 'localhost' (10061) Error
Posted on 2007-07-30
I'm creating a web app and i using a new host, i have created a very simple PHP page that connects to the database grabs all the rows from one table and prints them to a page. I have used this same test code many times i know the code is fine, in fact its pretty much the basic PHP MySQL connection code you'll find in any simple tutorial. However on my new host i get the following error messages:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in H:\myfile\myfolder\index.php on line 27
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in H:\myfile\myfolder\index.php on line 28
Database NOT Found
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in H:\myfile\myfolder\index.php on line 54
Where is this error coming from, could it be the users and permissions in MySQL. I am very new to MySQL i am using PHPMyAdmin. I don't really know how to setup user correctly to access data from PHP pages. Could wrong user settings be the problem or is this error something else?