Fedora16下安装mysql

高级搜索|网站地图|TAG标签 RSS订阅[设为首页] [加入收藏]

当前位置: > Linux发行版 > Fedora >

Fedora16下安装mysql

时间:2015-09-25 08:54来源:linux.it.net.cn 作者:IT

yum方式安装及配置

$> 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]#

(责任编辑：IT)

------分隔线----------------------------

上一篇：如何在 Fedora 上设定和取消 IPv6 地址
下一篇：Fedora 23 正式版现已提供下载

栏目列表

推荐内容

热点内容