mysql 5 on linux手动安装方法（mysql 5 is linux手动安装方法）.doc

下载文档 降价啦

0
0
约3.42千字
约 6页
2017-08-20 发布于河南
举报
版权申诉
保障服务

mysql 5 on linux手动安装方法（mysql 5 is linux手动安装方法）.doc

1、本文档共6页，可阅读全部内容。
2、原创力文档（book118）网站文档一经付费（服务费），不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
3、本站所有内容均由合作方或网友上传，本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺！文档内容仅供研究参考，付费前请自行鉴别。如您付费，意味着您自己接受本站规则且自行承担风险，本站不退款、不进行额外附加服务；查看《如何避免下载的几个坑》。如果您已付费下载过本站文档，您可以点击这里二次下载。
4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“版权申诉”（推荐），也可以打举报电话：400-050-0827(电话支持时间：9:00-18:30)。

mysql 5 on linux手动安装方法（mysql 5 is linux手动安装方法）

mysql 5 on linux手动安装方法（mysql 5 is linux手动安装方法） Manual installation method for MySQL 5 on Linux 1. download the mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz and recommend the ICC version, which is said to be 10-20% higher than GCC 2. copy to /usr/local/, unzip: tar, zxvf, mysql-standard-5.x....tar.gz 3. add users and groups mysql: Groupadd MySQL Useradd -g MySQL MySQL 4. create a symbolic link: /usr/local ln -s mysql-standard-5.x MySQL #... 5. CD mysql, the current directory is changed to /usr/local/mysql/ 6. run the steps to initialize the database:./scripts/mysql_install_db --user=mysql 7. set permissions: /usr/local/mysql # chown -R root. /usr/local/mysql chown -R MySQL data # /usr/local/mysql chgrp -R MySQL # 8. create and modify /etc/my.cnf as needed, refer to configuration: [mysqld] # default settings for the INNODB table, support services: Default-storage-engine=INNODB # set the default character set: Default-character-set=utf8 # disable bdb: Skip-bdb 9. start MySQL: /usr/local/mysql/bin --user=mysql ./mysqld_safe # 10. initializes the root password: /usr/local/mysql/bin./mysqladmin -u root -p password # password-of-root Enter password: enter old password, press Enter directly 11. create a database with root login: /usr/local/mysql./mysql -u root -p # Enter password: password-of-root Create a new user: Mysql, create, user, test, identified, by,test-password; Create a new database: Mysql create database testdb; Grant test users access to testdb from localhost: Mysql, grant, all, on, testdb.*, to, test@localhost; Stop the MySQL server: /usr/local/mysql/bin./mysqladmin -u root -p shutdown # Enter password: password-of-root STOPPING, server, from, PID, file, /usr/local/mysql/data/debian.pid XXX mysqld ended 1. download the mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz and recommend the ICC version, which is said to be 10-20% higher than GCC 2. copy to /usr/local/, unzip: tar, zxvf, mysql-standard-5.x....tar.gz 3. add users and groups mysql: Groupadd