在Linux上安装MySQL5安装方法.docx

《在Linux上安装MySQL5安装方法.docx》由会员分享，可在线阅读，更多相关《在Linux上安装MySQL5安装方法.docx（2页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、1 .下,n,推荐ICC版本,据称比GCC性能 提高10-20%.复制至lj/usr/local/, 解压：tar zxvf mysql-standard-5.x. tar.gz2 .添加用户和组mysql：groupadd mysqluseradd -g mysql mysql3 .创建符号连接：/usr/local # In -s mysql-standard-5.x .mysql. cd mysql,当前目录改为/usr/local/mysql/4 .运行脚步初始化数据库：./scripts/mysql_install_db user=mysql.设置权限：/usr/local/mysq

2、l # chown -R root./usr/local/mysql # chown -R mysql data/usr/local/mysql # chgrp -R mysql5 .根据需要创建并修改/etc/f,参考配置：mysqld设置默认为INNODB表，支持事务：default-storage-engine=INNODB设置默认的字符集：default-character-set=utf8禁用bdb：skip-bdb9 .启动 MySQL：/usr/local/mysql/bin # ./mysqld_safe user=mysql &.初始化root 口令：/usr/local/m

3、ysql/bin # ./mysqladmin -u root -p password password-of-root1Enter password: v输入旧 口令，直接按 Enter10 .以root登录创建数据库：/usr/Iocal/mysql # ./mysql -u root -pEnter password: password-of-root创建一个新用户：mysql create user test identified by test-password;创建一个新数据库：mysql create database testdb;赋予test用户从localhost访问testdb的权限：mysql grant all on testdb.* to testlocalhost;停止MySQL服务器：/usr/local/mysql/bin # ./mysqladmin -u root -p shutdownEnter password: password-of-rootSTOPPING server from pid file /usr/local/mysql/data/debian.pidxxx mysqld ended