一、linux安装mysql
一、下载mysql免编译包:
wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
二、安装
#1、解压tar -zxvf /mnt/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz#2、移动文件到/usr/local/mysqlmv /mnt/mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql#3、针对mysql增加用户groupadd mysqluseradd -g mysql -M mysql#4、将文件存入到/mnt/sata1/mysql/data ,并授权mkdir -p /mnt/sata1/mysql/datachown -R mysql:mysql /mnt/sata1/mysql/data
yum install perl -yyum install -y perl-Module-Install.noarch
#5、初始化MySQL数据库/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/sata1/mysql/data --user=mysql#6、#修改配置文件sed -i "s?# basedir = .....?basedir = /usr/local/mysql?g" /usr/local/mysql/my.cnfsed -i "s?# datadir = .....?datadir = /mnt/sata1/mysql/data?g" /usr/local/mysql/my.cnfsed -i "s?# port = .....?port = 3306?g" /usr/local/mysql/my.cnf#7、添加mysqld 成为系统服务并设置自启动cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchkconfig --add mysqldchkconfig mysqld onmkdir /var/log/mariadb#8、启动/etc/init.d/mysqld startln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock#9、设置密码/usr/local/mysql/bin/mysqladmin -u root password '010209'service mysqld restartecho 'export MYSQL_HOME=/usr/local/mysql' >> /etc/profileecho 'export PATH=$PATH:$MYSQL_HOME/bin' >> /etc/profilesource /etc/profile#10、开启远程访问mysql -uroot -p010209 -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '010209' WITH GRANT OPTION;FLUSH PRIVILEGES;"#删除多于用户用于远程CDH在安装时密码不正确mysql -uroot -p010209 -e "delete from mysql.user where host<>'%';"service mysqld restart~
三、安装时遇到的相关错误总结
1、初始化MySQL数据库时:
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/sata1/mysql/data --user=mysql
出现以下错误:
/usr/local/mysql/scripts/mysql_install_db: /usr/bin/perl: 坏的解释器: 没有那个文件或目录
解决方法:
yum install perl
安装以后再次初始化数据库
报错:
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/sata1/mysql/data --user=mysql
出现:
FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:
Data::Dumper
解决办法:
yum install -y perl-Module-Install.noarch
安装以后再次初始化数据库
2、设置密码时错误
/usr/local/mysql/bin/mysqladmin -u root password '1234'
出现以下错误:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
解决办法:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
3、MySQL [ERROR] Table 'mysql.user' doesn't exist
https://www.cnblogs.com/yfb918/p/10635496.html
最新文章
- Android之仿微信Tab滑动
- Python的高级特性8:你真的了解类,对象,实例,方法吗
- Codeforces Round #364 (Div. 2) B. Cells Not Under Attack
- 直观友好的单个memcache监控工具:phpmemcache.php
- 2. npm 的使用
- NOI2005维修数列 splay
- JMX 与系统管理--转
- IOS6和IOS7 显示一样的SearchBar
- maven 添加memcached.jar配置方法
- ajax交互数据简单拼装,数组成字符串
- python入门-基础语法
- HttpWatch的Result中出现Aborted的原因分析
- Dropout正则化和其他方法减少神经网络中的过拟合
- day 46 html 学习 列 表格,
- 集合--(List、Set、Map)遍历、删除、比较元素时的小陷阱
- 三、Kubernetes之深入了解Pod
- 启明星请假系统appform:流程在线帮助
- SQL Server查询时添加一列连续的自增列
- linux修改 时间 时区
- Opcode查看利器之vld