jalen Posted May 10, 2009 Share Posted May 10, 2009 It's a long story, by default mysql password is root, I changed this to my own password. I used it to login, create database, table etc and use it with php. everything works fine, I was able to create my programs etc up until today. my program work yesterday fine with the given username and password, database and table etc it. today I run it again and it gives me an error: . Can't connect to MySQL server on 'localhost' (10061) i went to mysql and login with my password, that I could login yesterday but today it won't let me login. Not sure why, could someone help me to understand why and how I could reset my password, maybe that would help to work. thanks Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/ Share on other sites More sharing options...
PFMaBiSmAd Posted May 10, 2009 Share Posted May 10, 2009 Searching for that error message gives the following information - The error - Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server. Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-830978 Share on other sites More sharing options...
jalen Posted May 10, 2009 Author Share Posted May 10, 2009 It should work, b/c the same program work yesterday, and today I run it it doesn't work. Do you know why it might have work yesterday and not today? Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-830979 Share on other sites More sharing options...
jalen Posted May 10, 2009 Author Share Posted May 10, 2009 I went to mysql command line and login in with the password from the php program I created but I couldn't login in, why is that? Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-830981 Share on other sites More sharing options...
Daniel0 Posted May 10, 2009 Share Posted May 10, 2009 Have you checked the things mentioned in the quotation posted by PFMaBiSmAd? Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-830992 Share on other sites More sharing options...
jalen Posted May 10, 2009 Author Share Posted May 10, 2009 yea b/c one of my php, I just found out works fine, the other two shows that error. but these two were working fine yesterday until today, any reason why? i went to mysql command line and couldn't login with the same password i was able to login yesterday, any reason why? how can i reset or change my password? Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-830997 Share on other sites More sharing options...
jalen Posted May 10, 2009 Author Share Posted May 10, 2009 I have reinstalled mysql and seems like the database, table that I've created is still there, could some one tell me why is that? now by default my username is root, and my password, before installation is also root, I was able to now sign on to the mysql command line, and change the password on the PHP program and run it and this is the error I got: . Access denied for user 'ODBC'@'localhost' (using password: NO) I also noticed that there is a database in mysql that I didn't create, called information_schema that I am trying to drop but couldn't do it. could someone help thanks Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-831016 Share on other sites More sharing options...
Daniel0 Posted May 10, 2009 Share Posted May 10, 2009 now by default my username is root, and my password, before installation is also root, I was able to now sign on to the mysql command line, and change the password on the PHP program and run it and this is the error I got: . Access denied for user 'ODBC'@'localhost' (using password: NO) Seems like you aren't providing any username or password. I also noticed that there is a database in mysql that I didn't create, called information_schema that I am trying to drop but couldn't do it. could someone help thanks It's used internally by MySQL. Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-831021 Share on other sites More sharing options...
jalen Posted May 12, 2009 Author Share Posted May 12, 2009 Daniel0, something is very strange. I uninstalled and re-installed mysql, and adjust the php program for the new user name and password. again yesterday after I did this it runs fine. I leave the password as root, and again today I run my php program in my local environment and nothing show, no result, no error just a blank screen. and then when I open mysql command line and then login in using the password i know it work yesterday and today it didn't work. Could you explain to me why my php program is blank and why the command line login didn't work when it work yesterday with the same password?? thx Quote Link to comment https://forums.phpfreaks.com/topic/157587-lost-my-mysql-password/#findComment-832069 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.