mysql for centos6.5 安装
来源:互联网 发布:广州红砖厂淘宝摄影 编辑:程序博客网 时间:2024/05/18 01:54
安装前置文件:
yum -y install perl perl-devel
yum install -y perl-Data-Dumper
yum install libaio* -y
tar -zxvf mysql-advanced-5.6.21-linux-glibc2.5-x86_64.tar.gz -C /usr/local
cd /usr/local
mkdir mysql
mv mysql-advanced-5.6.21-linux-glibc2.5-x86_64/* mysql
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
---初始化库
./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
--添加mysql到服务开机启动
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
---启动mysql 服务
service mysqld start
--添加PATH
vim /etc/profile
--在最后,添加:
export PATH="/usr/local/mysql/bin:$PATH"
--保存,退出,然后运行:
source /etc/profile
mysql -u root -p
报错 提示 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (1)
执行 ln -s /var/local/mysql/mysql.sock /tmp/mysql.sock
--修改ROOT密码
set password=PASSWORD('root');
FLUSH PRIVILEGES;
exit;
退出,再重新登录 设置远程登录
设置本机被远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
yum -y install perl perl-devel
yum install -y perl-Data-Dumper
yum install libaio* -y
tar -zxvf mysql-advanced-5.6.21-linux-glibc2.5-x86_64.tar.gz -C /usr/local
cd /usr/local
mkdir mysql
mv mysql-advanced-5.6.21-linux-glibc2.5-x86_64/* mysql
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
---初始化库
./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
--添加mysql到服务开机启动
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
---启动mysql 服务
service mysqld start
--添加PATH
vim /etc/profile
--在最后,添加:
export PATH="/usr/local/mysql/bin:$PATH"
--保存,退出,然后运行:
source /etc/profile
mysql -u root -p
报错 提示 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (1)
执行 ln -s /var/local/mysql/mysql.sock /tmp/mysql.sock
--修改ROOT密码
set password=PASSWORD('root');
FLUSH PRIVILEGES;
exit;
退出,再重新登录 设置远程登录
设置本机被远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
阅读全文
0 0
- mysql for centos6.5 安装
- centos6.5 安装navicat for mysql
- centos6.5安装mysql
- Centos6.5 mysql安装
- centOS6.5安装mysql
- CentOs6.5 安装mysql
- centos6.5安装mysql
- centos6.5安装mysql
- CentOS6.5 安装 Mysql
- Centos6.5 安装mysql
- centos6.5安装mysql
- centos6.5安装mysql
- centos6.5安装mysql
- centos6.5安装mysql
- centos6.5安装mysql
- centos6.5 安装 mysql
- Ganglia 安装 for centos6.5
- Oracle12c for CentOs6.5安装
- 前后端分开开发
- linux安装、配置、使用supervisor
- Ubuntu 17.10 进系统卡死 (禁用Nvidia卡驱动)
- 通过maven下载依赖包速度慢或失败的解决方法
- 一文读懂深度学习与机器学习的差异
- mysql for centos6.5 安装
- Python很简单?学会魔术方法才算入门!
- 深入理解java解析、分派和绑定
- Spring加载properties文件
- 惹毛程序员的十件事!需求变更居然不是排第一!
- Oracle定时任务
- JavaMail 邮件附件名乱码问题 (长度问题)
- Spring框架分为哪七大模块
- Echart3