Ubuntu View and modify mysql login name and password, install phpmyadmin

After installing MySQL, enter mysql -u root -p in the terminal and press Enter. After entering the password, it prompts access denied......ues password YES/NO error

The reason is that the username or password is incorrect!

View and modify mysql username and password

first step:

At this time, you need to enter the /etc/mysql directory, then sudo vim/vi debian. to view the username and password in it, and then use the username and password in this file to enter mysql. If the username in debian.cnf is debian-sys-maint, then:

mysql -u debian-sys-maint -p Press Enter. You will be asked to enter your password. Copy the password in debian.cnf (do not enter it manually as it is easy to make mistakes).

Now you can enter mysql

Step 2:

Modify root password

Log in to the MySQL client according to the previous step

mysql> use mysql;
Database changed
mysql> update user set password=password('new password') where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit

Step 3:

Log in with the newly changed root and password to view.

Install phpmyadmin

1. Open the terminal, enter sudo apt-get install phpmyadmin , and press Enter

2. Then, after the installation is complete, check the Apache server directory (which has been changed from /var/www/html to /media/home/ivalley) and find that there is no such file or folder as phpmyadmin.

3. Here is the key point. When the system installs the software, it is installed in /usr/share/ by default, so your phpmyadmin can be found in /usr/share

4. Therefore, we must create a soft link to sudo ln -s /usr/share/phpmyadmin /media/home/ivalley/phpmyadmin

5. Next, open the browser, enter http://localhost/phpmyadmin, enter your account name and password, and you can log in smoothly and use the MySQL database happily.

Summarize

The above is what I introduced to you about how to view and modify the login name and password of MySQL on Ubuntu and install phpmyadmin. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time!