Shulou(Shulou.com)06/01 Report--

This article mainly introduces the solution to the 1044 error in mysql, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The solution to the 1044 error in mysql: first, enter the cmd mode into the bin directory of mysql, and enter the relevant code; then open a dos window, also cut to the mysql bin directory, and enter the relevant code; finally, set the password.

The solution to a 1044 error in mysql:

The error is that there may be a problem with the configuration of sql_mode in this file my-default.ini or this file my.ini (corresponding to your own version). You can delete it and follow the steps below.

1. Enter the bin directory of mysql in cmd mode, enter D:\ Program Files\ MySQL\ MySQL Server 5.6\ bin > mysqld-- defaults-file= "D:\ Program Files\ MySQL\ MySQL Server 5.6\ my-default.ini"-- console-- skip-grant-tables, and press enter.

2014-08-29 10:40:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use

2014-08-29 10:40:48 8108 [Note] Plugin 'FEDERATED' is disabled.

2014-08-29 10:40:48 8108 [Note] InnoDB: Using atomics to ref count buffer pool pages

2014-08-29 10:40:48 8108 [Note] InnoDB: The InnoDB memory heap is disabled

2014-08-29 10:40:48 8108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2014-08-29 10:40:48 8108 [Note] InnoDB: Memory barrier is not used

2014-08-29 10:40:48 8108 [Note] InnoDB: Compressed tables use zlib 1.2.3

2014-08-29 10:40:48 8108 [Note] InnoDB: Not using CPU crc32 instructions

2014-08-29 10:40:48 8108 [Note] InnoDB: Initializing buffer pool, size = 128.0m

2014-08-29 10:40:48 8108 [Note] InnoDB: Completed initialization of buffer pool

2014-08-29 10:40:48 8108 [Note] InnoDB: Highest supported file format is Barracuda.

2014-08-29 10:40:57 8108 [Note] InnoDB: 128rollback segment (s) are active.

2014-08-29 10:40:57 8108 [Note] InnoDB: Waiting for purge to start

2014-08-29 10:40:57 8108 [Note] InnoDB: 5.6.20 started; log sequence number 1625997

2014-08-29 10:40:57 8108 [Note] Server hostname (bind-address):'*'; port: 3306

2014-08-29 10:40:57 8108 [Note] IPv6 is available.

2014-08-29 10:40:57 8108 [Note] -:: 'resolves to'::'

2014-08-29 10:40:57 8108 [Note] Server socket created on IP:':'

2014-08-29 10:40:58 8108 [Note] mysqld: ready for connections.

Version: '5.6.20' socket:''port: 3306 MySQL Community Server (GPL)

Seeing this result shows that MySQL is up.

2. Open another dos window, also cut to the mysql bin directory, enter D:\ Program Files\ MySQL\ MySQL Server 5.6\ bin > mysql-u root mysql, and enter enter

Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 1Server version: 5.6.20 MySQL Community Server (GPL) mysql >

The mysql database is connected and you can enter the mysql command.

3. Set the password

Mysql > update user set password=PASSWORD ('password') where user='root';Query OK, 2 rows affected (0.02 sec) Rows matched: 3 Changed: 2 Warnings: 0mysql > FLUSH PRIVILEGES; mysql > quit

Then connect to mysql in the normal way. If you can't connect, check to see if the mysql service starts.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the solutions to the 1044 errors in mysql. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.