#1045 Cannot log in to the MySQL server
Posted by: suffs10 (---.qubee.com.bd)
Date: July 30, 2013 07:59AM

Hi all, I have installed wamp few days ago. On the first day,it worked well. I used "root" as username and blank password. I did not change anything. But today I can't login. I am trying to use "root" as username and blank password as usual. But it is showing this message " #1045 Cannot log in to the MySQL server". In config.inc.php, it is also $cfg['Servers'][$i]['AllowNoPassword'] = true;

I did not change password or did nothing. Still can't login. Please suggest me.

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: suffs10 (---.qubee.com.bd)
Date: July 30, 2013 08:07AM

I have installed wamp few days ago. On that day I logged in with user name "root" and left password blank. I did not do anything on that. But today, I can't login. I am getting this message: #1045 Cannot log in to the MySQL server.

So I could login with root and blank password few days ago,now I can't without changing anything. I have also checked config.inc.php where $cfg['Servers'][$i]['AllowNoPassword'] = true; .

Please suggest me regarding this initial stage of painful trouble.

Thanks

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: suffs10 (---.qubee.com.bd)
Date: July 30, 2013 08:48AM

My icon is yellow and mysql is not starting.I think it is the problem,but it was not 2 days ago. How to solve it?

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: RiggsFolly (---.as13285.net)
Date: July 30, 2013 11:01AM

Install TeamViewer and I will troubleshoot for you.

Install TV, then run it.

Do this before attempting a connection.

How to Configure Team Viewer so it does not require port 80 or 443

Run TV
Extras -> Options -> Advanced -> Press the Advanced Button -> Advanced Network Connections

Check the checkbox saying [ Dont use incomming port 80 (recommended for web servers only ) ]
Stop and restart TV.

Then
Send me a Private Message containing the TV ID and PASSWORD so I can connect.
Leave TV running as it will change the password each time you restart it.

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: suffs10 (---.qubee.com.bd)
Date: July 30, 2013 11:53AM

ID: 697 971 053
password: 6090

I have installed wamp at E drive ( Because tried at C & D drive for testing).

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: RiggsFolly (---.as13285.net)
Date: July 30, 2013 01:39PM

Sorry misssed your message.

I said send me a Private Message with your Team Viewer information, I get an email from that to let me know you are ready.

Also dont post it here Anybody can see it.


Try again.

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: suffs10 (---.qubee.com.bd)
Date: August 01, 2013 02:37PM

Thank you for your great efforts! I was about to install new window for it,but you did it here. Lot of thanks, wish you best of luck smiling smiley

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: niladridey933 (103.17.84.---)
Date: August 05, 2013 10:19AM

Hi
I am having that same problem . I can not log into the phpmyadmin . Can you please help me too ?

Thanks
Nil

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: RiggsFolly (---.as13285.net)
Date: August 05, 2013 10:41AM

That guys problem was that he installed another piece of software that itself installed anuther copy of apache and mysql.

Are you sure you only have one version of both?

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: newkadr (---.hsd1.wa.comcast.net)
Date: September 26, 2014 02:28AM

Hello,

I'm getting the same error as visitor that started this thread. So far I have followed the instructions from this [www.programming-techniques.com] link and so far no luck. Please advice.

Alex

Options: ReplyQuote
Re: #1045 Cannot log in to the MySQL server
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: September 26, 2014 10:28AM

Hi newkadr,

Can you answer these questions please [forum.wampserver.com]

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.