mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 09:07PM

I installed wamp 2.1d to machine (windows 7), i can't connect to mysql when i start mysql console and hit the enter can't login.

What is the problem i didn't change anything ?

How could i change mysql password if i cant login ?

Error is: access denied for user root (using password NO).

thnx

Options: ReplyQuote
Re: mysql defult password
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: March 17, 2011 09:09PM

maybe wamps mysql is not running.. and another mysql is installed..?

wamp by default has no password...

make sure the wamp icon is green

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 09:12PM

wamp icon is orange

Options: ReplyQuote
Re: mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 09:16PM

if i try to connect to database with phpmyadmin is error to #1045 - Access denied for user 'root'@'localhost' (using password: NO)

but my localhost work ok

Why wamp icon is orange ?

thnx

Options: ReplyQuote
Re: mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 09:24PM

i tried to another machine with windows xp everthing works ok

Options: ReplyQuote
Re: mysql defult password
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: March 17, 2011 09:34PM

you have mysql installed seperatly already on this machine.. you will need to stop it

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 09:46PM

where can i find and stop already installed mysql ?

Options: ReplyQuote
Re: mysql defult password
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: March 17, 2011 09:49PM

click start> type in

services.msc


on the list find

MYSQL

right click> properites.

click stop.. and change the startup type to DISABLED

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 10:05PM

i stop mysql but still got the orange icon (i restarted all services)

i try to start my wampmysql manualy in services.msc but i cant.

error 1067 the process terminated undexpectedly

wampapache has status started

can be a problem that i have installed sql server 2008 ( can't be?)

Options: ReplyQuote
Re: mysql defult password
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: March 17, 2011 10:19PM

yes it could be as they would use the same port -


but first search your pc for MY.INI

delete any that are not in the wamp folder.


if this doesnt work , ill explain how to have MSSQL AND MySQL Running together

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: mysql defult password
Posted by: mihap (77.111.12.---)
Date: March 17, 2011 10:29PM

now working

thnx for help

i must invite you for a beer smiling smiley

Options: ReplyQuote
Re: mysql defult password
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: March 17, 2011 10:33PM

id love one! eating Tortillias with coke.. beer would be much better!

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.