我要评论检查是否已经安装了mysql
rpm -qa|grep mysql
卸载mysql
rpm -e --nodeps 程序名
- 上传文件
mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
- 解压文件，并将解压后的文件重命名，移动到/usr/local/mysql
tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz mv mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql cd /usr/local/mysql
- 添加一个mysql 用户组
groupadd mysql
- 添加一个用户
useradd -r -g mysql mysql
- 创建文件夹 用来存放数据
- /usr/local/mysql/data
mkdir /usr/local/mysql/data
- 进入mysql包中， 给这个包授权 给
- mysql/usr/local/mysql
chown -r mysql:mysql ./ chown -r mysql:mysql data
- 进入mysql文件名 basedir 为mysql 的路径， datadir 为mysql的 data 包，里面 存放着mysql自己的包
yum install -y libaio bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
- 进入support-file 文件夹
cd support-files/
- 复制文件
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
- 修改basedir= 自己的路径 修改datadir= 自己的路径
vim /etc/init.d/mysqld
basedir=/usr/local/mysql datadir=/usr/local/mysql/data
- 启动mysql
bin/mysqld_safe --user=mysql & //或者 service mysqld start
- 加入开机启动项目
chkconfig --add mysqld //查看开机启动項 chkconfig --list
- 重启mysql
/etc/init.d/mysqld restart
- bin目录下 连接数据库
./mysql -uroot -p 临时密码
发生错误
执行：
ln -s /usr/local/mysql/bin/mysql /usr/bin
- 修改密码
set password= password('root');
//或者
alter user 'root'@'localhost' identified by 'root';
//刷新权限
flush privileges;
//授权新用户
grant all privileges on *.* to 'root1'@'%' identified by 'root' with grant option;
- .配置全局环境变量
vi /etc/profile //加入 path=/data/mysql/bin:/data/mysql/lib:$path export path //配置文件立即生效 source /etc/profile
- 解决 数据库乱码问题
- 将my.cnf拷贝到/etc/下
# for advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [client] # pipe # # socket=0.0 port=3306 default-character-set=utf8 [mysql] port=3306 default-character-set=utf8 # [mysqld] # # remove leading # and set to the amount of ram for the most important data # cache in mysql. start at 70% of total ram for dedicated server, else 10%. # innodb_buffer_pool_size = 128m # # remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # remove leading # to set options mainly useful for reporting servers. # the server defaults are faster for transactions and fast selects. # adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128m # sort_buffer_size = 2m # read_rnd_buffer_size = 2m datadir=/usr/local/mysql/data #socket=/var/lib/mysql/mysql.sock server_id=1 expire_logs_days=3 # disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 port=3306 character-set-server=utf8 log-error=/var/log/mysqld.log #pid-file=/var/run/mysqld/mysqld.pid pid-file=/usr/local/mysql/data/localhost.localdomain.pid
总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持代码网。
发表评论