Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to solve the problem that the mysql web side cannot be accessed

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Editor to share with you how to solve the problem that can not be accessed on the mysql web side, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

The solution that the mysql web side cannot access: first set the installation directory of mysql and set the data storage directory of the mysql database; then set the default character set of the mysql client; finally, set the default port used by the mysql client to connect to the server.

Mysql has been started locally, but can not be accessed directly on the web page.

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

# setting mysql installation directory basedir=E:/Develop/mysql# setting mysql database data storage directory datadir=E:/Develop/mysql/data [mysqld] # setting port 3306 port=3306# setting mysql installation directory basedir=E:/Develop/mysql# setting mysql database data storage directory datadir=E:/Develop/mysql/data# allows the maximum number of connections max_connections=200# allows the number of connection failures This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

Modified to:

# set mysql installation directory basedir=E:\ Develop\ mysql# set mysql database data storage directory datadir=E:\ Develop\ mysql\ data [mysqld] # set port 3306 port=3306# set mysql installation directory basedir=E:\ Develop\ mysql# set mysql database data storage directory datadir=E:\ Develop\ mysql\ data# maximum number of connections max_connections=200# allows the number of failed connections. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

Summary: generally modify server files, configuration files should pay attention to the problem of slashes.

The above is all the content about how to solve the problem that cannot be accessed on the mysql web side. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report