Linux下MySQL5.6源码安装
来源:互联网 发布:苹果下载软件itunes 编辑:程序博客网 时间:2024/06/05 15:58
1、首先安装依赖包,避免在安装过程中出现问题
shell>yum install cmake --(mysql5.5以后是通过cmake来编译的)shell>yum install ncurses-devel --Redhat执行cmake是需要依赖的包,如缺少编译报错shell>yum install bison-develshell>yum install libaio-develshell>yum install gcc-c++
2、创建mysql用户及用户组
shell> groupadd mysqlshell> useradd -r -g mysql mysql // -r option means mysql is only a system account and can't login as a regular usershell> id mysqluid=497(mysql) gid=502(mysql) 组=502(mysql)
3、创建mysql的安装目录及数据库存放目录
shell> mkdir -p /db/mysql #安装mysql shell> mkdir -p /db/mysql/data #存放数据库
4、安装mysql
shell> unzip mysql-5.6.19.zipshell> cd mysql-5.6.19shell> cmake . -DCMAKE_INSTALL_PREFIX=/db/mysql -DMYSQL_DATADIR=/db/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_cishell> make && make install
CMAKE参数说明:
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql //默认安装目录
-DINSTALL_DATADIR=/usr/local/mysql/data //数据库存放目录
-DDEFAULT_CHARSET=utf8 //使用utf8字符
-DDEFAULT_COLLATION=utf8_general_ci //校验字符
-DEXTRA_CHARSETS=all //安装所有扩展字符集
-DENABLED_LOCAL_INFILE=1 //允许从本地导入数据
-DMYSQL_USER=mysql
-DMYSQL_TCP_PORT=3306
CMAKE详细介绍参见
注意事项:
如安装失败重新编译时,需要清除旧的对象文件和缓存信息。
shell> make clean
shell> rm -f CMakeCache.txt
shell> rm -rf /etc/my.cnf
5、设置目录权限并创建系统数据库的表
shell> chown -R mysql.mysql /db/mysqlshell> cp /db/mysql/support-files/my-default.cnf /etc/my.cnf shell> cp /db/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql //将mysql的启动服务添加到系统服务中shell> /db/mysql/scripts/mysql_install_db --basedir=/db/mysql/ --datadir=/db/mysql/data/ --user=mysql
6、设置环境变量
shell> vi /root/.bash_profilePATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/mysql/libshell> source /root/.bash_profile
7、开启mysql服务
shell> service mysql startStarting MySQL....... [确定]shell> chkconfig --add mysql //加入开机启动服务
8、修改MySQL的root用户的密码以及打开远程连接
shell> mysql -u root mysqlmysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "passwd";Query OK, 0 rows affected (0.09 sec)mysql> update user set password=password('passwd') where user='root';mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitshell>mysql -u root -pEnter password:
不能通过嵌套文件方式连接
[1]shell> mysql -u root mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)shell> ls /tmp/mysql.sock ls: 无法访问/tmp/mysql.sock: 没有那个文件或目录shell> ln -s /db/mysql/data/mysql.sock /tmp/mysql.sockshell> ls /tmp/mysql.sock/tmp/mysql.sock[2]修改配置文件/etc/my.cnf并重启mysql服务器指定socket=/tmp/mysql.sock [3]通过TCP/IP连接shell> mysql -h 127.0.0.1 -u root mysqlshell> mysql -u root mysql
整理自网络
Svoid
2014-07-18
0 0
- Linux下MySQL5.6源码安装
- linux下Mysql5.6源码安装
- LINUX 环境下源码方式安装mysql5.6
- ubuntu/ linux下源码安装mysql5.5
- LINUX环境下MYSQL5.5源码安装
- Linux下SOURCE源码安装mysql5.5
- Linux下源码安装MySQL5.6.30
- Linux下源码安装MySQL5.6.30
- Linux下源码安装mysql5.7.17
- linux下安装mysql5.6
- linux下安装mysql5.6
- mysql5.6 linux下安装
- Linux下MYSQL5.6安装
- Linux下安装MySQL5.6
- cnetos6.3下mysql5.6源码安装
- RedHat6下源码安装MySQL5.6
- linux通过源码包安装mysql5.6
- linux下安装MySQL5
- Linux卸载MySQL
- ABAP内表操作
- reactor
- c#与vc调用动态链接库
- uIP学习笔记
- Linux下MySQL5.6源码安装
- Help Jimmy(POJ No.1661) 动态规划
- pb常用代码
- 浅谈java中类型转换
- sklearn学习记录二:数据预处理
- Windows安装MongoDB
- Linux Ubuntu学习笔记_终端
- 角色的转换
- 弹出对话框--AlertDialog