Yyds dry goods inventory ubuntu18 0.4 install MySQL and solve error 1698: access denied for user ''root' '@' 'localhost' '

Recent learning linux, And then win Instead of ubuntu. Previously installed mysql It can't be used , Now it will be in ubuntu18.0.4 Installation on mysql And record the problems encountered as follows ：

Download and install mysql

Execute statement ​​sudo apt-get install mysql-server​​

Because I have installed it here , So this will happen . Can pass mysql –version Check the installed version .

Sign in mysql

Execute statement ​​mysql -u root -p​​

Its -u yes user -p Is the port . Appears at login ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’. This should be when we installed ,pass Forget or don't remember to initialize pass Caused by the ：

Now let's talk about how to solve this problem ：

1. Input instruction ​​sudo vim /etc/mysql/debian.cnf ​​ We will see the following information ：

among debian-sys-maint Account is installed mysql The system automatically generates mysql user , Corresponding pass This is the user's pass.

2. Login account debian-sys-maint：

​​mysql -u debian-sys-maint -p ​​ You can log in. mysql：

3. modify root Account number pass：

Input instruction use mysql;

Then enter the command ：

      
      

       
       UPDATE 
       
       user 
       
       SET 
       
       authentication_string
       
       =
       
       PASSWORD(
       
       ‘ What you want to set pass
       
       ') where USER=‘root';
       
        This is the setup root account pass.
      
      
      
      

       
       
1.
      
      

Then enter the command quit, sign out mysql, restart mysql Instructions sudo service mysql restart;

Then login mysql, When executed mysql -u root -p, Found or reported wrong ：ERROR 1524 (HY000): Plugin ‘msyql_native_password’ is not loaded

Now pass In fact, it has been modified successfully , yes plugin root The field of is auth_socket, It needs to be modified .

4. modify plugin:

Continue to use ​​debian-sys-maint​​ Account login ;

Execution instruction ：

​​use mysql​​

Execution instruction ：

​​select user,plugin from user;​​

Then execute the instructions ：

      
      

       
       update 
       
       user 
       
       set 
       
       authentication_string 
       
       =
       
       password(
       
       ‘ What you want to set 
       
       '),plugin=‘mysql_native_password' 
       
       where 
       
       user
       
       =
       
       ‘root
       
       ';
      
      
      
      

       
       
1.
      
      

Finally, exit and restart mysql that will do ：