What are the operation instructions in MariaDB

This article mainly shows you "what are the operating instructions in MariaDB", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "what are the operating instructions in MariaDB" this article.

MariaDB1, change the database password.

Update mysql.user set password=password ('your new password') where user='root'; / / does not need to enter the mysql table.

OR:

Update user set password=password ('your new password') where user='root'; / / enters the mysql table.

OR:

Set password for 'root'@'localhost'=password (' your new password'); / / do not enter the table.

Flush privileges

2. View databases and tables

Show databases; / / View the database

Show tables; / / View the table

The above is all the contents of the article "what are the operating instructions in MariaDB?" 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!