how to install/start mysql? 1

[cyan01]

Hi, Experts,

I just downloaded mysql-essential-4.1.9-win32 and mysql-4.1.9-win32.zip. I have ran mysql-essential-4.1.9-win32 and followed every steps. But at the last step, I choose not to auto start mysql. Here are my questions:

1) Do I still need to install mysql-4.1.9-win32.zip or it is already installed by mysql-essential-4.1.9-win32?

2) If mysql is installed by only running mysql-essential-4.1.9-win32, how to start it?

3) If mysql can not be installed bby runnning mysql-essential-4.1.9-win32, then what's mysql-essential-4.1.9-win32 for?

Many thanks!

 

[TonyGroves]

The "essential" package is just a stripped-down version of the "full" MySQL package, but it still contains everything you need for everyday operation of a MySQL database. You would install either one of those packages, not both.

If you chose to install MySQL as a service with the name "mysql", then you can use the command "net start mysql" to start the service, and "net stop mysql" to stop it. If you later wish to have MySQL always started automatically, you can specify that in the Services applet in the Windows Control Panel.

 

[cyan01]

Thank you!

I started mysql using the command you told me:

C:\>net start mysql
The MySQL service is starting.
The MySQL service was started successfully.

However, how can I get mysql prompt?

Here is what I did:

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

What should I do?

 

[TonyGroves]

I don't know where the user name "ODBC" could have come from if you didn't specify it.

Since you presumably haven't set up the user accounts yet, you should be able to connect as one of the predefined users at localhost, either an anonymous user:
[tt] mysql[/tt]
or as root:
[tt] mysql -u root[/tt]

 

[cyan01]

Thank you fopr your post.

here is what I got:

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

=====================

I must have missed some important step! Any clue?

 

[TonyGroves]

Sorry, I notice the Windows installer asks you to supply a root password, and doesn't create an anonymous user account automatically. If the root password is "123abc", then the following should work:
[tt] mysql -u root -p123abc[/tt]

 

[guestgulkan]

I know that on windows systems - that if you use mysql without supplying a username in the way that cyan01 did - then you will get that ODBC error.

 

[cyan01]

Tony, do you mean I might have missed a step to set a root passwd? I don't recall. And I don't think I was asked to set up an account during my installation - it does not make sense, does it? Account seyupo should be done at configuration step, right?

So, what should I do now? Uninstall/reinstall it?

Thanks!

 

[TonyGroves]

As you have noticed, there are several packages for installing MySQL on Windows:

(1) The Windows non-installer package, which you simply unzip, copy into a directory, and configure manually, includes four pre-defined user accounts with no passwords, which you can use immediately after configuration.
(2) The "full" Windows installer package and "essential" Windows installer package both guide you through the configuration process, which includes asking you to specify a root password, and allowing you to set up an anonymous user if you wish. If you did specify a root password and can't remember it, and did not set up an anonymous user, then you're stuck; there's no way you can connect to MySQL.

However, all is not lost. The file

http://homepage.eircom.net/~tonygroves/temp/mysql-user.zip

contains a default MySQL user table containing two user accounts: a root user (with password "123abc" and full privileges) connecting from localhost, and an anonymous user (with no password and limited privileges) conecting from anywhere. If you download that file, stop the MySQL server, unzip the file into your MySQLServer\data\mysql directory (replacing the existing files), and restart the server, you should then be able to logon as either of those users.

 

[cyan01]

Thank you, Tony. With your help, I can use my MySql now. Thanks again.