Home Database Mysql Tutorial MySQL 5 on Linux手动安装操作方案

MySQL 5 on Linux手动安装操作方案

Jun 07, 2016 pm 04:11 PM
linux mysql Install operate article plan

以下的文章主要讲述的是MySQL 5 on Linux手动安装操作的具体方法,我们一共对其分成11部分,望你在浏览之后会对MySQL 5 on Linux手动安装操作有所收获,以下就是文章的具体操作内容。 1. MySQL 5 on Linux手动安装方法之一, 下载MySQL(和PHP搭配之最佳组合)

以下的文章主要讲述的是MySQL 5 on Linux手动安装操作的具体方法,我们一共对其分成11部分,望你在浏览之后会对MySQL 5 on Linux手动安装操作有所收获,以下就是文章的具体操作内容。

1. MySQL 5 on Linux手动安装方法之一,

下载"MySQL(和PHP搭配之最佳组合)-standard-5.0.27-linux-i686-icc-glibc23.tar.gz",推荐ICC版本,据称比GCC性能提高10-20%

2. 复制到/usr/local/,解压:

tar zxvf MySQL(和PHP搭配之最佳组合)-standard-5.x....tar.gz

3. 添加用户和组MySQL(和PHP搭配之最佳组合):

groupadd MySQL(和PHP搭配之最佳组合)

useradd -g MySQL(和PHP搭配之最佳组合) MySQL(和PHP搭配之最佳组合)

4. 创建符号连接:

/usr/local # ln -s MySQL(和PHP搭配之最佳组合)-standard-5.x... MySQL(和PHP搭配之最佳组合)

5. cd MySQL(和PHP搭配之最佳组合),当前目录改为/usr/local/MySQL(和PHP搭配之最佳组合)/

6. 运行脚步初始化数据库

./scripts/MySQL(和PHP搭配之最佳组合)_install_db --user=MySQL(和PHP搭配之最佳组合)

7. 设置权限:

/usr/local/MySQL(和PHP搭配之最佳组合) # chown -R root .

/usr/local/MySQL(和PHP搭配之最佳组合) # chown -R MySQL(和PHP搭配之最佳组合) data

/usr/local/MySQL(和PHP搭配之最佳组合) # chgrp -R MySQL(和PHP搭配之最佳组合)

8. MySQL 5 on Linux手动安装过程中根据需要创建并修改/etc/my.cnf,参考配置:

[MySQL(和PHP搭配之最佳组合)d]

# 设置默认为INNODB表,支持事务:

default-storage-engine=INNODB

# 设置默认的字符集:

default-character-set=utf8

# 禁用bdb:
http://www.knowsky.com
skip-bdb

9. 启动MySQL(和PHP搭配之最佳组合):

/usr/local/MySQL(和PHP搭配之最佳组合)/bin # ./MySQL(和PHP搭配之最佳组合)d_safe --user=MySQL(和PHP搭配之最佳组合) &

10. 初始化root口令:

/usr/local/MySQL(和PHP搭配之最佳组合)/bin # ./MySQL(和PHP搭配之最佳组合)admin -u root -p password "password-of-root"

Enter password:

11. 以root登录创建数据库:

/usr/local/MySQL(和PHP搭配之最佳组合) # ./MySQL(和PHP搭配之最佳组合) -u root -p

Enter password: password-of-root

创建一个新用户:

MySQL(和PHP搭配之最佳组合)> create user test identified by 'test-password';

创建一个新数据库:

MySQL(和PHP搭配之最佳组合)> create database testdb;

赋予test用户从localhost访问testdb的权限:

MySQL(和PHP搭配之最佳组合)> grant all on testdb.* to test@localhost;

停止MySQL(和PHP搭配之最佳组合)服务器:

/usr/local/MySQL(和PHP搭配之最佳组合)/bin # ./MySQL(和PHP搭配之最佳组合)admin -u root -p shutdown

Enter password: password-of-root

STOPPING server from pid file /usr/local/MySQL(和PHP搭配之最佳组合)/data/debian.pid

xxx MySQL(和PHP搭配之最佳组合)d ended

以上的相关内容就是对MySQL 5 on Linux手动安装方法的介绍,望你能有所收获。


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article

Hot Article

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

deepseek web version entrance deepseek official website entrance deepseek web version entrance deepseek official website entrance Feb 19, 2025 pm 04:54 PM

deepseek web version entrance deepseek official website entrance

Android TV Box gets unofficial Ubuntu 24.04 upgrade Android TV Box gets unofficial Ubuntu 24.04 upgrade Sep 05, 2024 am 06:33 AM

Android TV Box gets unofficial Ubuntu 24.04 upgrade

How to install deepseek How to install deepseek Feb 19, 2025 pm 05:48 PM

How to install deepseek

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

BitPie Bitpie wallet app download address BitPie Bitpie wallet app download address Sep 10, 2024 pm 12:10 PM

BitPie Bitpie wallet app download address

BITGet official website installation (2025 beginner's guide) BITGet official website installation (2025 beginner's guide) Feb 21, 2025 pm 08:42 PM

BITGet official website installation (2025 beginner's guide)

Zabbix 3.4 Source code compilation installation Zabbix 3.4 Source code compilation installation Sep 04, 2024 am 07:32 AM

Zabbix 3.4 Source code compilation installation

Detailed explanation: Shell script variable judgment parameter command Detailed explanation: Shell script variable judgment parameter command Sep 02, 2024 pm 03:25 PM

Detailed explanation: Shell script variable judgment parameter command

See all articles