Linux下MySQL安装详解_MySQL
安装前期准备
1.需要mysql安装包,并解压,解压命令 tar -zxvf +压缩包名
2.将其复制到需要安装的位置
我打算安装到/usr/local/mysql目录下
3.创建mysql用户与mysql组,用于管理mysql
开始安装
1.配置安装等信息
./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-extra-charsets=all --with-unix-socket-path=/usr/local/mysql/var/mysql.sock --with-named-curses-libs=/lib/libncursesw.so.5
查看安装配置参数方式./configure –help<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310U1GZ-11c06.jpg" class="lazy" alt="这里写图片描述" title="\"><br>配置常用参数说明:
参数 |
说明 |
---|---|
–prefix=/usr/local/mysql/ |
安装路径 |
–with-charset=utf8 |
mysql默认字符集 |
with-extra-charsets=all |
支持多语言 |
–with-unix-socket-path=/usr/local/mysql/var/mysql.sock |
这个是指定mysql服务器启动后,联机套接字文件所处的位置和文件名,也就是说,如果CentOS mysql服务器成功启动后,就能在//usr/local/mysql/mysql/var目录中看到mysql.sock文件。如果看不到,肯定是CentOS mysql启动不了 |
–with-named-curses-libs=/lib/libncursesw.so.5 |
为了让mysql能够识别出路径 |
mysql允许的字符集有<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310U50-124E9.jpg" class="lazy" alt="这里写图片描述" title="\"><br>配置完成界面如下<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310U6250-13c29.jpg" class="lazy" alt="这里写图片描述" title="\"><br>2.执行make命令<br>如果此时提示如下错误<br>No curses/termcap library found<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310UY060-141331.jpg" class="lazy" alt="这里写图片描述" title="\"><br>解决办法:<br>解决方式(CentOS)<br>yum list"grep ncurses<br>yum -y install ncurses-devel<br>最后界面如下<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310V1250-15SJ.jpg" class="lazy" alt="这里写图片描述" title="\"><br>3.执行make install 命令
4.创造mysql授权表<br>做了这些工作以后,还得创造CentOS mysql授权表,否则数据库也是启动不了。mysql安装的命令都安装到了/usr/local/mysql/bin这个目录中。<br>运行mysql_install_db命令过后,我们查看/usr/local/mysql就会发现,有个var的目录。这个目录,就是用来装所有数据库的位置,比如我们创建了xxpt的数据库后,就在在/usr/local/mysql/var目录中有xxpt的目录。<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310V3Z60-164517.jpg" class="lazy" alt="这里写图片描述" title="\">
启动MySQL
启动mysql<br>mysql.server start<br><img src="/static/imghw/default1.png" data-src="http://img.bitscn.com/upimg/allimg/c160504/14623310V5N10-1M336.jpg" class="lazy" alt="这里写图片描述" title=""><br>关闭mysql<br>mysql.server stop<br>mysql.server文件位于/usr/local/mysql/share/mysql目录中。
以上就是Linux下MySQL安装详解_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

DeepSeek is a powerful intelligent search and analysis tool that provides two access methods: web version and official website. The web version is convenient and efficient, and can be used without installation; the official website provides comprehensive product information, download resources and support services. Whether individuals or corporate users, they can easily obtain and analyze massive data through DeepSeek to improve work efficiency, assist decision-making and promote innovation.

One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app

There are many ways to install DeepSeek, including: compile from source (for experienced developers) using precompiled packages (for Windows users) using Docker containers (for most convenient, no need to worry about compatibility) No matter which method you choose, Please read the official documents carefully and prepare them fully to avoid unnecessary trouble.

BITGet is a cryptocurrency exchange that provides a variety of trading services including spot trading, contract trading and derivatives. Founded in 2018, the exchange is headquartered in Singapore and is committed to providing users with a safe and reliable trading platform. BITGet offers a variety of trading pairs, including BTC/USDT, ETH/USDT and XRP/USDT. Additionally, the exchange has a reputation for security and liquidity and offers a variety of features such as premium order types, leveraged trading and 24/7 customer support.

Ouyi OKX, the world's leading digital asset exchange, has now launched an official installation package to provide a safe and convenient trading experience. The OKX installation package of Ouyi does not need to be accessed through a browser. It can directly install independent applications on the device, creating a stable and efficient trading platform for users. The installation process is simple and easy to understand. Users only need to download the latest version of the installation package and follow the prompts to complete the installation step by step.

Gate.io is a popular cryptocurrency exchange that users can use by downloading its installation package and installing it on their devices. The steps to obtain the installation package are as follows: Visit the official website of Gate.io, click "Download", select the corresponding operating system (Windows, Mac or Linux), and download the installation package to your computer. It is recommended to temporarily disable antivirus software or firewall during installation to ensure smooth installation. After completion, the user needs to create a Gate.io account to start using it.

Ouyi, also known as OKX, is a world-leading cryptocurrency trading platform. The article provides a download portal for Ouyi's official installation package, which facilitates users to install Ouyi client on different devices. This installation package supports Windows, Mac, Android and iOS systems. Users can choose the corresponding version to download according to their device type. After the installation is completed, users can register or log in to the Ouyi account, start trading cryptocurrencies and enjoy other services provided by the platform.

Gate.io is a highly acclaimed cryptocurrency trading platform known for its extensive token selection, low transaction fees and a user-friendly interface. With its advanced security features and excellent customer service, Gate.io provides traders with a reliable and convenient cryptocurrency trading environment. If you want to join Gate.io, please click the link provided to download the official registration installation package to start your cryptocurrency trading journey.
