mysq安装总结_MySQL
1:到官方网站下载指定的安装包
地址为http://dev.mysql.com/downloads/mysql/5.6.html#downloads,下载名为Linux - Generic (glibc 2.5) (x86, 64-bit), Compressed TAR Archive
的文件,下载完成后的文件为mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz。至于你是怎么放到linux里面就随你了,可以用rz,或者直接在linux里面wget下载二进制安装文件。我下载下来放在/root下面
2:创建mysql安装用户
直接查看INSTALL-BINARY文件当中有创建用户的语句。
语句为
groupadd mysql useradd -r -g mysql mysql
3: 为前面解压的目录在/usr/local/下创建一个软连接,并且附权限。
cd /usr/local ln -s /opt/mysql/mysql-5.6.27-linux-glibc2.5-x86_64 mysql chown -R mysql:mysql mysql chown -R mysql:mysql mysql/
4: 创建mysql数据库的数据目录,binlog目录和tmp目录
mkdir /data/mysql/{data,logs,tmp} chown -R mysql:mysql /data/mysql
5: 配置my.cnf文件。
主要是配置user,datadir,tmpdir,binlog,配好以后放到你想放置的地方,一般放在/etc下。
6:初始化data数据库目录
cd /usr/lcoal/mysql .scripts/mysql_install_db --defaults-file='/etc/my.cnf'
看到两个ok就可以了。
到这里所有的安装工作就都好了。
以上就是mysq安装总结_MySQL的内容,更多相关内容请关注PHP中文网(www.php.cn)!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]
