Set / Change / Reset the MySQL root password on Ubuntu Linux

[ron]

# Stop the MySQL Server.

Код:

sudo /etc/init.d/mysql stop

# Start the mysqld configuration.

Код:

sudo mysqld --skip-grant-tables &

# Login to MySQL as root.

Код:

mysql -u root mysql

# Add user

Код:

CREATE USER 'bob'@'localhost' IDENTIFIED BY '654321';

# Replace YOURNEWPASSWORD with your new password!

Код:

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;