Change mysql root or username passwordMethod 1
# /etc/init.d/mysql stopor# killall mysqld# mysqld –skip-grant-tables# mysqladmin -u root password ‘newpasswd’# /etc/init.d/mysql start
Method 2
# mysql -u root mysqlmysql> UPDATE USER SET PASSWORD=PASSWORD(“newpassword”) where user=’root’;mysql> FLUSH PRIVILEGES; # Use username instead of “root”mysql> quit
Create user and database
# mysql -u root mysqlmysql> CREATE DATABASE bobdb;mysql> GRANT ALL ON *.* TO [...]
