dhapp
asked on
How do I configure MySQL
I am trying to configure MySQL 5.1 and come to a screen that wants to know the current root password. I don't know what to enter.
I am installing this on my single user machine, which uses XP Pro. I do not have any passwords set on the machine since I am the only one who uses it.
MySQL.JPG
I am installing this on my single user machine, which uses XP Pro. I do not have any passwords set on the machine since I am the only one who uses it.
MySQL.JPG
ASKER
Thanks for taking a stab at my problem. The link that you offered was not helpful for the following reason: It seems to assume that you can get into a MySQL console in order to run a script. But when I open the console I am prompted for a password, which I do not know, since I never set one.
The screen shot is where I am stuck.
I am brand new to MySQL, and, as such, know nothing about it. I want to get it installed so I can start learning.
I am willing to completely remove it from my machine and start over but think that I will just get stuck at the very same place (screen shot).
I am willing to call someone who might be able to provide help with this issue.
The screen shot is where I am stuck.
I am brand new to MySQL, and, as such, know nothing about it. I want to get it installed so I can start learning.
I am willing to completely remove it from my machine and start over but think that I will just get stuck at the very same place (screen shot).
I am willing to call someone who might be able to provide help with this issue.
keep current root password blank and put new root password and confirm the same and try.
or
untick modify security setting
or
tick on create an anonymous account
and cont..
bm keshav
or
untick modify security setting
or
tick on create an anonymous account
and cont..
bm keshav
ASKER
I uninstalled MySQL but the MySQL service remained.
I downloaded the latest version and installed it.
I tried all of the suggestions that you made. The only one that allowed me to complete the installation wizard was to untick the 'Modify Security Setting'
When I run MySQL I get the dreaded Error Nr. 1045 Access denied for user 'root'@'localhost' (Using Password:No).
Doomed.
I downloaded the latest version and installed it.
I tried all of the suggestions that you made. The only one that allowed me to complete the installation wizard was to untick the 'Modify Security Setting'
When I run MySQL I get the dreaded Error Nr. 1045 Access denied for user 'root'@'localhost' (Using Password:No).
Doomed.
ASKER
I have removed the MySQL Service, rebooted and reinstalled MySQL using the wizard.
This time instead of asking for the existing password it just asked for a new password and to confirm it.
But alas I still get the 1045 error. Access denied for user 'root'@'localhost' (Using Password:No).
Any ideas on how to get MySQL installed.
This time instead of asking for the existing password it just asked for a new password and to confirm it.
But alas I still get the 1045 error. Access denied for user 'root'@'localhost' (Using Password:No).
Any ideas on how to get MySQL installed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bm
thanks for responding.
Your questions are what I need two days ago.
I am very new to this and my problem was that I did not have the proper environment for MySQL. I bought a book Saturday and followed the instructions to load MySQL, Apache and PHP. I now have it functioning properly.
thanks for responding.
Your questions are what I need two days ago.
I am very new to this and my problem was that I did not have the proper environment for MySQL. I bought a book Saturday and followed the instructions to load MySQL, Apache and PHP. I now have it functioning properly.
See the following link
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html