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

Here are two common ways to solve the initialization of mysql passwords in ubuntu. The secret of the text is to be close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on two common ways to solve the initialization of mysql passwords in ubuntu.

There are two ways to solve mysql password initialization in ubuntu:

(1) Open the / etc/mysql/debian.cnf file, in which the user name and password assigned to us by default by the system can be directly operated on mysql through this password. But generally speaking, this password is rather strange, very long.

(2) change the password of mysql after entering mysql: this method is better. The specific operation is as follows: set password for 'root'@'localhost' = password (' yourpass'); after modification, you can operate mysql normally.

Mysql-u username-p mysql (enters command line mode)

I don't know why the input password is the password of the system user, not the password of the mysql database.

Connect to the database remotely:

There's a very detailed process here.

Http://jingyan.baidu.com/article/ea24bc398522b3da62b331d3.html

DESCRIBE table name; view table structure

Show tables; lists all current tables

Select user (); view the current user

Show databases; displays all databases

Which database is entered by the use database name

For the above two common methods to solve the initialization of mysql password in ubuntu, is there anything else you don't understand? Or if you want to know more about it, you can continue to follow our industry information section.

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.