Newbie installing mySQL on WIN98 machine...password problem! 1

[lanm]

I'm trying to install mySQL on my WIN98 machine (I ran the setup.exe file), and am never prompted for a password when I run the configuration wizard. When I try to then run the command window, I'm asked for the password. Can I change some config file or ini file?

I'm selecting either Detailed or Standard Configuration, and don't ever get the prompt for password.

The checkbox for "Install as windows service" is disabled, so I can't check it.

Thanks!

 

[TonyGroves]

When you install MySQL using the installation wizard, you should be invited to enter a password for the "root" user, and also to set up credentials for other users. If you skipped those bits, then you probably only have a user called "root" with full privileges and no password. In that case you should be able to start the mysql command-line client with "mysql -u root". You then need to set up user accounts; you can use the mysql command "select user,host,password from mysql.user;" and take it from there.

You can't install MySQL as a service on Windows 98; that applies only to Windows NT/2000/XP. With Windows 98, you have to run the MySQL server as an application instead.

You might also like to download MySQL Administrator and MySQL Query Browser from the MySQL website; they're much friendlier than the command-line program.

 

[lanm]

TonyGroves!

Thanks! It was weird since I did the same thing on my XP machine at work, and was prompted for all the credentials.

I'll try your suggestions, and let you know!