SQL语句

1，创建用户  并开启相应权限

create user arunu1107;GRANT ALL PRIVILEGES ON *.* TO arunu1107@'%' IDENTIFIED BY '****'; mysql> FLUSH PRIVILEGES;mysql> quit

/etc/init.d/mysql restart

2，修改用户密码

# /etc/init.d/mysql stop# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &# mysql -u root mysqlmysql> UPDATE user SET Password=PASSWORD('****') where USER='root';mysql> FLUSH PRIVILEGES;mysql> quit# /etc/init.d/mysql restart# mysql -uroot -pEnter password: <输入新设的密码newpassword>