MySQL 常用命令及应用收藏

// 新增数据库及用户授权

CREATE DATABASE mydata;

GRANT ALL PRIVILEGES ON mydata.* TO "user"@"localhost" IDENTIFIED BY "password";

FLUSH PRIVILEGES;

// 修改密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

// 修改MySql 默认数据库目录为 /myfold/data 

service mysqld stop
cd /myfold
cp -R /usr/local/mysql/data/* /myfold/data
chown -R mysql:mysql /myfold/data

//*  修改配置文件 */

#vi /etc/rc.d/init.d/mysqld
datadir=/myfold/data

#service mysqld restart

// 丢失root密码时，重设密码 /

mysqld_safe --skip-grant-tables& mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';
mysql> FLUSH PRIVILEGES;