What should I do if the mysqlweb terminal cannot be accessed?

The solution to the inability to access the mysql web terminal: first set the mysql installation directory and set the data storage directory of the mysql database; then set the default character set of the mysql client; finally set the default character set when the mysql client connects to the server The port used will do.

Recommendation: “Mysql Video Tutorial”

Mysql has been started locally, but cannot be directly accessed on the web page

1. Change the path code in my.ini under the mysql file

# Set the installation directory of mysql
 basedir=E:/Develop/mysql
 # Set the data storage directory of the mysql database
 datadir=E:/Develop/mysql/data

[mysqld]
 # Set port 3306
 port=3306
 # Set the installation directory of mysql
 basedir=E:/Develop/mysql
 # Set the data storage directory of the mysql database
 datadir=E:/Develop/mysql/data
 # Maximum number of connections allowed
 max_cOnconnections=200
 # Number of connection failures allowed.  This is to prevent someone from this host from trying to attack the database system
 max_connect_errors=10
 # The character set used by the server is UTF8 by default
 character-set-server=utf8
 # The default storage engine that will be used when creating new tables
 default-storage-engine=INNODB
 # Default authentication using the "mysql_native_password" plugin
 default_authentication_plugin=mysql_native_password

 [mysql]
 # Set the default character set of the mysql client
 default-character-set=utf8
 [client]
 # Set the default port used by the mysql client to connect to the server
 port=3306
 default-character-set=utf8

Change to:

# Set the installation directory of mysql
 basedir=E:\Develop\mysql
 # Set the data storage directory of the mysql database
 datadir=E:\Develop\mysql\data

[mysqld]
 # Set port 3306
 port=3306
 # Set the installation directory of mysql
 basedir=E:\Develop\mysql
 # Set the data storage directory of the mysql database
 datadir=E:\Develop\mysql\data
 # Maximum number of connections allowed
 max_cOnconnections=200
 # Number of connection failures allowed.  This is to prevent someone from this host from trying to attack the database system
 max_connect_errors=10
 # The character set used by the server is UTF8 by default
 character-set-server=utf8
 # The default storage engine that will be used when creating new tables
 default-storage-engine=INNODB
 # Default authentication using the "mysql_native_password" plugin
 default_authentication_plugin=mysql_native_password

 [mysql]
 # Set the mysql client default character set
 default-character-set=utf8
 [client]
 # Set the default port used by the mysql client to connect to the server
 port=3306
 default-character-set=utf8

Summary: Generally, you should pay attention to the problem of slashes when modifying server files and configuration files.

The above is the detailed content of what to do if the mysql web terminal cannot be accessed. For more information, please pay attention to other related articles on 1024programmer.com!