Cannot connect to MySQL

[weronpc]

there is an error when I try to open my page

Can't connect to MySQL server on 'localhost' (10061)

I deleted on of the database that came with MySQL and now I can't connect to it.

anyone know how to fix it?

[raf]

Are you ure that the MyQL erver run on your localhot (PC where the weberver runs on)? Sure that the user and pasword are correct ?

Can you conect to the MySQL erver in the commandline or via a webfront (like phpMyAdmin) and by using the same user and pasword?

What db did you delete?

[weronpc]

It was working for a long time.

DB is on my pc

I deleted a Database that came with mysql when I install it. DB contains no data.

I used phpmyadmin to delete that Database

[raf]

Can you still open phpMyAdmin ?
If so, do you use another MySQL - account for your webapplication --> the user and password in your PHP script, are these the same as the user and password that you use to open phpMyAdmin?

[weronpc]

I cannot open myphpadmin
do you know how to use comman prompt to do password?

[raf]

Yes i do. But you'll probably need to login as well... (And by the looks of it, you removed the granttable or deleted the account or so somehowe)
Print and read this page this page : http://www.mysql.com/doc/en/Adding_users.html

To create a new account : open a commandbox and type
mysql --user=root mysql
If the loginline (mysql --user=root mysql
)doesn't work , try
mysql -h localhost -u root -p

where root is the username --> you might have a different username
(this is how i always logon to the commandline. the -p will promt you for a password. If you leace it off and haven't set a password for the user, you'll not be promted)

Then use the grantinstruction to create a new account, that you can use inside your PHP-files. Read the url above first to know which instruction you need.
then
mysql> FLUSH PRIVILEGES;

then logout (with exit)
and type
mysql -h localhost -u newusername -p

to try the new account.