Troubleshooting of common mysql errors and troubleshooting of mysql errors

Troubleshooting of common mysql errors and troubleshooting of mysql errors

1. mysql service cannot be started and error 1067 is reported

Solution:
1). decompress the mysql Server Directory and add a new my. ini file. The content is as follows:

[Mysqld] # set basedir to installation path, e.g ., c:/mysql # set it to the installation directory basedir = c:/tool/mysql5617win32 # set datadir to location of data directory, # e.g ., c:/mysql/data or d:/mydata/data # Set it to the MYSQL data DIRECTORY datadir = c: /tool/mysql5617win32/datacharacter_set_server = utf8character_set_client = utf8 [WinMySQLadmin] Server = c: /tool/mysql5617win32/bin/mysqld.exe user = root # No password = 123456 # No password is used here # The above is the configuration of WinMySQLadmin [Client] user = root # No password is used here = 123456 # It seems useless here

2) input below dos: SC delete mysql
3) restart the computer
4). mysqld install MySQL -- defaults-file = "Your unzipping root directory \ my. ini", prompt: Service successfully installed.
5). net start mysql
6). Prompt that the startup is successful

2. the root password is changed to 10061.

1). 10061 is generally caused by the failure to start the mysql service. Check whether the service has been started.
2). If this error is still reported after the firewall is started, disable the firewall (required by the remote server)
3) at this time, there should be no 10061

3. the root password is changed to 10045.

1). Run cmd to enter the bin in the mysql decompression directory, for example, cd c:/tool/mysql5617win32/bin.
2) input: mysql-u root-p
3). enter password: Press enter directly (because there is no password at the beginning)
4). use mysql; probably displays: changed table success;
5). update user set password = PASSWORD ("123465") where user = 'root'; changed 3 may appear; updated 3 may appear.
6). flush privileges;
7) then open the client and enter your above 123456 to connect successfully.

MySQL problem summary report (job, none at all)

Problem description:

Start a Data Node
/Usr/local/mysql/bin/ndbd -- initial
/Usr/local/mysql/bin/ndbd: unknown variable 'Log-bin = mysql-bin'
Solution Process:

Solution: vim/etc/my. cnf comment log-bin = mysql-bin, server-id = 1, skip-locking
Cause analysis:

111015 7:30:10 [Warning] '-- skip-locking' isdeprecated and will be removed in a future release. Please use '-- skip-external-locking' instead.
Experience summary:

Some parameters will be discarded in the new version. You only need to follow the regular method and solve the problem as prompted.

Ecshop FAQ MySQL server error report: Array -- ecshop error

This means that there is no ecs_setup_keyword table in your database new. If this is the table that comes with ecshop, you can install an ecshop on your machine and check the table creation ddl, then create the table in the server database. If it is not the default ecshop table, some plug-ins you have installed are faulty. You can only exclude the plug-in. Contact the plug-in provider