Home / Database

Database

How to reset Password Mysql on Linux

How to reset Password Mysql on Linux

How to reset Password Mysql on Linux service mysqld stopmysqld_safe –skip-grant-tables &mysql -u root 3. 1 use mysql; 3.2 update user set authentication_string=PASSWORD(“mynewpassword”) where User=’root’; 3.3 flush privileges; 3.4 quit 4. service mysqld stop5. service mysqld start Bài viết liên quan 1. Linux mysql syntax 2. MySQL Master Master Repliction …

Read More »

Một vài lệnh MySQL phần 2

MySQL Tut P2 14. UPDATE command: UPDATE <Table_Name> SET (Column_Name = ‘value’) WHERE (Condition); mysql> select * from authors; +----+-------------------+ | Id | Name              | +----+-------------------+ | 1  | Jack London       | | 2  | Honore de Balzac  | | 3 …

Read More »

Một vài lệnh MySQL phần 1

MySQL Tut Some commands in MySQL you need to be remembered: 1. Show version: mysql> select version(); +-----------+ | version() | +-----------+ | 5.5.12    | +-----------+ 1 row in set (0.03 sec) mysql> 2. Create a new database: mysql> create database demo; Query OK, 1 row affected (0.01 sec) …

Read More »
0902 780 887