建组、建用户:
[root@dbking mysql]# groupadd mysql
[root@dbking mysql]# useradd -g mysql mysql
解压安装程序:
[root@dbking mysql]# tar -zxvf mysql.tar.gz
[root@dbking mysql]# mv /rpm/mysql /usr/local/mysql
初始化:
[root@dbking mysql]# ./scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql
配置文件:
[root@dbking mysql]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
log_error=mysql.err
修改目录权限:
[root@dbking mysql]# chown -R mysql:mysql /usr/local/mysql/
修改环境变量:
export PATH=/usr/local/mysql/bin:$PATH
启动数据库:
[mysql@dbking ~]$ /usr/local/mysql/bin/mysqld --user=mysql &
或者
[mysql@dbking ~]$ /usr/local/mysql/bin/mysqld_safe --user=mysql &
设置mysql开机自动启动:
[root@dbking mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
[root@dbking mysql]# chown -R root:root /etc/rc.d/init.d/mysqld
[root@dbking mysql]# chmod 755 /etc/rc.d/init.d/mysqld
[root@dbking mysql]# chkconfig --add mysqld
[root@dbking mysql]# chkconfig --list mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@dbking mysql]# service mysqld status
ERROR! MySQL is not running
mysql的root用户授权:
mysql> grant all privileges on *.* to 'root'@'%' identified by 'oracle';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> set password for 'root'@'%'=password('oracle');
Query OK, 0 rows affected (0.00 sec)