Shulou(Shulou.com)05/31 Report--

This article is about what to do with mysql: [ERROR] unknown option'--skip-grant-tables' errors in mysql databases. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Mysql database report ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

I read on the Internet that I want to configure my.ini.

I have a win10 system and I use mysql-5.7.18-winx64mysql

There is no my.ini in the file. If you see it on the Internet, you can build it yourself, so you add one to your home.

The contents are as follows:

[mysql] s

Kip-grant-tables

# set mysql client default character set

Default-character-set=utf8

[mysqld]

# set port 3306

Port = 3306

# set the installation directory of mysql

Basedir=C:\ Program Files\ mysql-5.7.18-winx64

# set the storage directory of the data in the mysql database

Datadir=C:\ Program Files\ mysql-5.7.18-winx64\ data

# maximum number of connections allowed

Max_connections=200

# the character set used by the server defaults to the 8-bit coded latin1 character set

Character-set-server=utf8

# default storage engine to be used when creating new tables

Default-storage-engine=INNODB

However, error report: mysql: [ERROR] unknown option'--skip-grant-tables'

My mysql is 5.0.7, and the console uses: mysqld-- skip-grant-tables when starting mysql. Notice that there are two middle horizontal lines.

Found on the Internet can be executed: mysqld-nt- skip-grant-tables

The solution to the problem of failure of command line mysqld-skip-grant-tables and unable to log in under mysql8.0 version

1, administrator permissions to log in to cmd, will not use the administrator to log in, please search cmd, search results right.

2. Enter net stop mysql; on the command line and then prompt. The service is stopping-> the service has been stopped. If there are other errors, please ask Baidu.

This is just an example. Please check the specific name of the service in the service. For example, mine is mysql57.

If the service will not be opened, please win+R-- > services.msc-- > enter and find the service name that begins with mysql.

3. Because the mysqld-skip-grant-tables measurement has failed in mysql8.0, mysqld-- console-- skip-grant-tables-- shared-memory is now used.

4. Open another cmd and log in directly without secret using mysql.

Thank you for reading! This is the end of the article on "mysql in mysql database: [ERROR] unknown option'--what to do with skip-grant-tables' errors?" I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.