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

This article mainly explains "how to configure administrator password under MySQL under Ubuntu". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian and go deep into it slowly to study and learn "how to configure administrator password under MySQL under Ubuntu" together!

Set root password to enter mysql

root@zack-desktop:~# sudo mysql -u root -pEnter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 45

Server version: 5.1.37-1ubuntu5 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Configure the administrator password for Ubuntu MySQL:

mysql> sudo mysqladmin -u root password newpassword or mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "password01! ";Query OK, 0 rows affected (0.00 sec)

Modify profiles to allow remote access or control

1 Create a new database for testing

mysql> create database test;

Query OK, 1 row affected (0.00 sec)

2 Add test_root administrator user to database

mysql> GRANT ALL PRIVILEGES ON test.* TO test_root@"%" IDENTIFIED BY "123456";

Query OK, 0 rows affected (0.14 sec)

3 Open the configuration file

$sudo gedit /etc/mysql/my.cnf

my.conf

Thank you for reading, the above is "MySQL under Ubuntu how to configure administrator password" content, after the study of this article, I believe that everyone on MySQL under Ubuntu how to configure administrator password this problem has a deeper understanding, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

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.