mysql安装与启动

为什么80%的码农都做不了架构师？>>>   

$> sudo yum install mysql mysql-server mysql-workbench

启动mysql

$> sudo systemctl start mysql.service

设置自动启动

$> sudo systemctl enable mysql.service 修改默认字符集，修改/etc/my.cnf文件 [mysqladmin] user=root

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 character-set-server=UTF8 port=3306

[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

[client] default-character-set=UTF8 port=3306 socket=/var/lib/mysql/mysql.sock 查看默认字符集 mysql> show variables like 'collation_%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-----------------+ 3 rows in set (0.00 sec) 设置root密码

未设置过root密码

mysqladmin -u root password 123456

设置过密码的

[root@yuan yuan]# mysqladmin -u root -p password Enter password: ****** New password: 123456 Confirm new password:123456 [root@yuan yuan]#

转载于:https://my.oschina.net/jaakan/blog/280255