4、linux 上安装mysql
来源:互联网 发布:淘宝网禁止出售动植物 编辑:程序博客网 时间:2024/06/14 07:31
1.基本信息版本 5.5.39安装机器 172.24.5.173账号 root源路径 /opt/software/mysql_5.5.39_product6.5_new.tar.gz目标路径 /usr/local/mysql
2.安装过程
1).登陆172.24.5.173,切换用户名root,并进入软件包所在目录:
[root@bgs-5p173-wangwenting opt]# exit[root@bgs-5p173-wangwenting opt]# cd /opt/software
2).配置mysql用户(密码也设置为mysql):
[root@bgs-5p173-wangwenting software]# groupadd mysql[root@bgs-5p173-wangwenting software]# useradd -r -g mysql mysql
3).将mysql-5.5.39.tar.gz通过tar -xf命令解压缩至目的安装目录,,并设置软连接,配置目录归属为mysql账户、mysql群。如
[root@bgs-5p173-wangwenting software]# tar -zxvf mysql-${version}.tar.gz -C /usr/local[root@bgs-5p173-wangwenting local]# chown -R mysql:mysql /usr/local/mysql-${version}[root@bgs-5p173-wangwenting local]# ln -s /usr/local/mysql-${version}/ /usr/local/mysql[root@bgs-5p173-wangwenting local]# cd /usr/local[root@bgs-5p173-wangwenting local]# chown -R mysql:mysql mysql*
4).初始化mysql:
[root@bgs-5p173-wangwenting software]# cd /usr/local/mysql[root@bgs-5p173-wangwenting mysql]# cp support-files/my-medium.cnf /etc/my.cnf[root@bgs-5p173-wangwenting mysql]# cp support-files/mysql.server /etc/init.d/mysql.server[root@bgs-5p173-wangwenting mysql]# scripts/mysql_install_db --user=mysql
5).启动mysql服务:
[root@bgs-5p173-wangwenting software]# /usr/local/mysql/support-files/mysql.server start若出现Starting MySQL.. SUCCESS!结果代表启动成功。
6).在172.24.5.173上启动Mysql,进入mysql,修改密码以及权限:
# mysql -u root -pmysql> set password = password("1234");mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234';mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@baseline01 IDENTIFIED BY '1234';mysql>flush privileges;
进入mysql,且密码修改成功,则表示mysql安装和启动成功。
[root@bgs-5p173-wangwenting software]# mysql -u root -pmysql> set password = password("1234");mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234';mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@bgs-5p173-wangwenting IDENTIFIED BY '1234';mysql>flush privileges;进入mysql,且密码修改成功,则表示mysql安装和启动成功。
阅读全文
0 0
- 4、linux 上安装mysql
- 4、linux 上安装mysql
- linux上安装mysql
- linux上安装mysql
- Linux上安装MySQL
- linux上安装Mysql
- linux上安装mysql
- Linux上安装mysql
- Linux上安装MySQL
- Linux上安装MySQL
- linux上安装Mysql
- Linux上安装MySQL
- linux上安装MySQL
- linux上安装mysql
- linux上安装mysql
- linux 上安装mysql
- linux上安装mysql
- Linux 上安装MySQL安装
- mybtais获取插入数据的主键id
- 12、Ambari 环境搭建
- 【Linux】PCB中的task_struct结构体
- 5、hadoop的分布式安装
- Django 博客开发教程 11
- 4、linux 上安装mysql
- hbase集群安装
- 10、linux上安装hive
- 6、linux上安装kafka
- java基本数据类型的包装类
- 11、linux上安装mongodb
- 9、linux上安装nginx
- 12、TCP的粘包问题以及数据的无边界性
- 7、linux 上安装storm