ubantu18.04 cannot be used after installing MySQL database, not installed properly

Error message:

　　1.ubantu18.04 Install MySQL no prompt for password

2, using terminal installation Mysql-apt-config_0.8.10-1_all.deb still unsuccessful

3. ERROR 1698 (28000): Access denied for user ' root ' @ ' localhost

4. ERROR 1146 (42S02): Table ' mysql.role_edges ' doesn ' t exist

In the event of an error, we first think of the technical resources to solve, but we have tried many ways to solve the problem, and finally found that is

There is a problem with the installation process. Here are the installation steps, ubantu18.04 Pro test available:

First step: Download MySQL resources, before installing please uninstall before, be sure to uninstall clean

Click on the resources link to download, directly click No Thanks, just start my download.

Step Two: Install the downloaded release package by entering the following command in the terminal

　　sudo dpkg-i file path + filename　

You can also CD to the file directory:

　　

Step Three: Update package information from the MySQL apt repository using the following command

　　sudo apt-get update　　

　　

Fourth step: Install MySQL

　　sudo apt-get install Mysql-server　　

In this process there will be some versions of the selection, the first box we will follow the first option to select Version 8.0 (ubantu18.04 if the lower version will be problematic).

Then by default Select OK, select OK to confirm the installation. Then set your MySQL database root user's password, confirm the password. The following questions are then addressed:

　　

Choose the second one here, or you can only use sudo to access MySQL after installation, and you cannot access the database.

Summarize:

I encountered a lot of problems during the installation process, and finally I was able to thank the blogger for the help of the lone castle Aoyama lovers and official documents.

Other commands:

Check the status of MySQL:sudo service mysql status

Turn on MySQL server:sudo service mysql start

Shut down MySQL server:sudo service mysql stop

To uninstall MySQL command:

Resource one:completely uninstall MySQL under Ubuntu

Resource two:how to completely uninstall MySQL under Ubantu

ubantu18.04 cannot be used after installing MySQL database, not installed properly