1.上传安装包
rz 需要的安装包mariadb-10.0.14-linux-x86_64.tar.gz
2.解压
#tar xvf mariadb-10.0.14-linux-x86_64.tar.gz -C /opt
#mv mariadb-10.0.14-linux-x86_64 mariadb
3.添加用户和组
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /data/mysqdata/
4.修改配置文件
#cp /opt/mariadb/support-files/my-medium.cnf /etc/my.cnf
#vi /etc/my.cnf
[client]
port = 3306
socket = /data/mysqldata/mysql.sock
[mysqld]
basedir=/opt/mariadb
datadir=/data/mysqldata
user=mysql
port = 3306
socket = /data/mysqldata/mysql.sock
log-error
skip-external-locking
log-bin=mysql-bin
server-id = 1
[mysql]
no-auto-rehash
5.初始化
#/opt/mariadb/scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/opt/mariadb/ --datadir=/data/mysqldata/
6.修改.bash_profile文件
#vi ~/.bash_profile
PATH=$PATH:$HOME/bin:/opt/mariadb/bin
#source .bash_profile
7.配置自启动
#ln -s /opt/mariadb/support-files/mysql.server /etc/init.d/mysql
#chmod 755 /etc/init.d/mysql
#chkconfig mysql on
#vi /etc/rc.d/init.d/mysql
basedir=/opt/mariadb
datadir =/data/mysqldata
chown mysql.mysql /data/mysqldata/ -R
service mysql start #启动
vi /etc/profile #把mysql服务加入系统环境变量:在最后添加下面这一行
export PATH=$PATH:/opt/mariadb/bin
8.密码设置
#修改root密码:
mysqladmin -u root password "123456"
#删除没有密码的初始账号:
mysql -uroot -p
use mysql
delete from user where password="";