1.启动mysql服务
service mysqld start
2.建库-建用户-授权
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';
GRANT allprivileges ON databasename.tablename TO 'username'@'host'
flush privileges;
9.ROOT忘记密码
9.1修改mysql配置
# vi /etc/my.cnf
[mysqld]
skip-grant-tables
9.2 重启mysql
/etc/init.d/mysqld restart
9.3登录mysql
# /usr/bin/mysql
USE mysql ;
UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ;
flush privileges ;
9.4修改mysql 配置
删除skip-grant-tables
9.5重启mysql
/etc/init.d/mysqld restart
10.修改字符集
10.1修改配置文件,#vi /etc/my.cnf
[client]下一行加入default-character-set=utf8[server]下一行加入character-set-server=utf8如果my.cnf设置了default-storage-engine = MYISAM,则注释掉这一行
10.2重启服务
/etc/init.d/mysql restart
10.3查看修改结果
登陆:mysql -u root -p输入root密码mysql> show variables like 'char%';其中character_set_server utf8character_set_system utf8说明修改成功。
99.mysql异常
99.1 Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Linux会定时回收/tmp下的垃圾文件,故mysql找不到msyql.sock文件
解决办法:mysql -uroot -p -S /var/lib/mysql/mysql.sock