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

Download, install and configure mysql-8.0.15

1. Download the zip package on the official website (https://dev.mysql.com/downloads/mysql/)

2. Unpack to my D:\ mysql directory

3. Configure environment variables for mysql

Create a new system variable MYSQL_HOME and add the mysql installation directory D:\ mysql\ mysql-8.0.15-winx64 to:

Add the environment variable% MYSQL_HOME%\ bin to path (to avoid repeatedly switching paths when operating under the CMD window):

2. Start the mysql service

(at this point, if you are in a hurry to open cmd directly to start the mysql service, you will get an error: the service name is invalid. Because mysqld (dvv deamon-daemon) is not installed

1. Initialize

Open cmd to run as an administrator (no administrator will report an error: system error 5 denies access)

Mysqld-initialize-insecure

After initialization is completed, the directory is automatically saved in the database (data? Generate some files, so you don't need to create them manually as some blogs write, and if you don't initialize this step, you should report an error later (unverified, according to a blog).

2. Administrator permissions cmd install mysqld:

Mysqld-install

3. Administrator permission cmd to start the mysql service:

Net start mysql

4. Log in to mysql with the powershell connection that comes with windows (because our teacher is required to operate mysql under shell)

There are two ways to open powershell:

① searches for powershell administrator status in the windows start bar to open

② directly enter powershell into cmd and enter enter

Connect and log in to mysql:mysql-h host-u user-p after entering powershell

Host and user indicate the hostname and user name of the MySQL account running the MySQL server,-h indicates the server name,-u indicates that the user name root is the default highest privileged user name, and-p indicates that the password is empty if the password is left empty. Now I replaced it with myself, but why did I report a 1130 error?

Because my account does not allow remote login, I can only log in in localhost. At this time, as long as on the computer in localhost, after the administrator cmd logs in to mysql, change the "host" entry in the "user" table in the "mysql" database from "localhost" to "%".

Mysql-u root-pmysql > use mysql;mysql > update user set host='% 'where user =' root' and host='localhost';mysql > select host, user from user

Shut down (net stop mysql) and restart (net start mysql) the server to log in remotely to powershell. Connect to the mysql server successfully as shown below. Use quit to disconnect:

If you are logged in on the same computer that is running MySQL, you can omit the host by using the following command:

In addition: my first login connection mysql password input is directly enter the car without entering anything, join the encounter to enter the password but do not know the password of the friend can be Baidu, you can view the initial login password through the data directory with the suffix .err file, but also by changing the password after landing.

Summary

The above are the problems encountered in the process of installing mysql8.0.15 winx64 and connecting to the server in Win10 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.