- 注册新账号
- 配置实例
- 环境搭建
//安装mysql客户端
yum install mysql
//安装mysql服务器
yum install mysql-server
//无用,用于开发
yum install mysql-devel
//编辑配置文件
vi /etc/my.cnf
[client]
default-character-set=utf8
socket=/data/mysql/run/mysql.sock
[mysqld]
character_set_server=utf8
datadir=/data/mysql/data
socket=/data/mysql/run/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
user=mysql
socket=/data/mysql/run/mysql.sock
datadir=/data/mysql/data
log-error=/data/mysql/log/mysqld.log
pid-file=/data/mysql/run/mysqld.pid
[client]
default-character-set=utf8
socket=/data/mysql/run/mysql.sock
[mysqld]
character_set_server=utf8
datadir=/data/mysql/data
socket=/data/mysql/run/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
user=mysql
socket=/data/mysql/run/mysql.sock
datadir=/data/mysql/data
log-error=/data/mysql/log/mysqld.log
pid-file=/data/mysql/run/mysqld.pid
//创建db目录
mysql_install_db --basedir=/data/mysql/data --user=mysql
//启动实例
mysqld_safe&
//设置root用户密码
mysqladmin -uroot password xxx
//创建用户
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
//授权
GRANT privileges ON databasename.tablename TO 'username'@'host'
//删除无密码登陆
drop user 'xxx'@'xxx'delete from mysql.user where user='';
//刷新权限flush privileges;
//打开mysql端口
iptables -I INPUT 0 -p tcp --dport 3306 -j ACCEPT
安装jdk
安装tomcat