• Make sure that the server is running. If it is not, clients cannot connect to it. For example, if an attempt to connect to the server fails with a message such as one of those following, one cause might be that the server is not running: shell> mysql ERROR 2003: Can't connect to MySQL server on ' host_name' (111) shell> mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) • It might be that the server is running, but you are trying to connect using a TCP/IP port, named pipe, or Unix socket file different from the one on which the server is listening. To correct this when you invoke a client program, specify a option to indicate the proper port number, or a option to indicate the proper named pipe or Unix socket file. To find out where the socket file is, you can use this command: shell> netstat -ln grep mysql • Make sure that the server has not been configured to ignore network connections or (if you are attempting to connect remotely) that it has not been configured to listen only locally on its network interfaces. If the server was started with, it will not accept TCP/IP connections at all. If the server was started with, it will listen for TCP/IP connections only locally on the loopback interface and will not accept remote connections.

• Check to make sure that there is no firewall blocking access to MySQL. Your firewall may be configured on the basis of the application being executed, or the port number used by MySQL for communication (3306 by default). Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked.

Access denied for user 'root'@'localhost' (using password: YES) I also traditionally use Sequel Pro -- which migrated over from my old computer without any problems, and retained the connection details its always had.

Under Windows, applications such as ZoneAlarm or Windows Firewall may need to be configured not to block the MySQL port. • The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as binary distributions on Windows, or RPM distributions on Linux), the installation process initializes the MySQL data directory, including the mysql system database containing the grant tables. For distributions that do not do this, you must initialize the data directory manually. For details, see.

To determine whether you need to initialize the grant tables, look for a mysql directory under the data directory. (The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the mysql database directory. After doing so and starting the server, you should be able to connect to the server. • After a fresh installation, if you try to log on to the server as root without using a password, you might get the following error message. Shell> mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It means a root password has already been assigned during installation and it has to be supplied. See on the different ways the password could have been assigned and, in some cases, how to find it.

If you need to reset the root password, see instructions in. After you have found or reset your password, log on again as root using the (or ) option: shell> mysql -u root -p Enter password: However, the server is going to let you connect as root without using a password if you have initialized MySQL using (see for details). That is a security risk, so you should set a password for the root account; see for instructions. • If you have updated an existing MySQL installation to a newer version, did you run the script? If not, do so. The structure of the grant tables changes occasionally when new capabilities are added, so after an upgrade you should always make sure that your tables have the current structure. For instructions, see.

• Under Personal Settings, click General. • On the Outlook menu, click Preferences. • Under Folder list, clear the Group similar folders, such as inboxes, from different accounts check box.

• If a client program receives the following error message when it tries to connect, it means that the server expects passwords in a newer format than the client is capable of generating: shell> mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client For information on how to deal with this, see. • Remember that client programs use connection parameters specified in option files or environment variables. If a client program seems to be sending incorrect default connection parameters when you have not specified them on the command line, check any applicable option files and your environment. For example, if you get Access denied when you run a client without any options, make sure that you have not specified an old password in any of your option files!

You can suppress the use of option files by a client program by invoking it with the option. For example: shell> mysqladmin --no-defaults -u root version The option files that clients use are listed in. Ribbon does not show on excel for mac. Environment variables are listed in. • If you get the following error, it means that you are using an incorrect root password: shell> mysqladmin -u root -p xxxx ver Access denied for user 'root'@'localhost' (using password: YES) If the preceding error occurs even when you have not specified a password, it means that you have an incorrect password listed in some option file.