CentOS 6下编译安装mySQL5_MySQL
CentOS
bitsCN.com 一,准备工作
1,快速安装安装 CentOS6,安装时选择最小化安装.
2,安装mysql编译时需要的库文件,这时可以选择做光盘yum
[root@admin share] # cd /media/
[root@admin media] # mkdir CentOS
[root@admin media] # mount /dev/cdrom /media/CentOS
[root@admin media]# cd /etc/yum.repos.d/
[root@admin yum.repos.d] # mv CentOS-Base.repo CentOS-Base.repo.bak
[root@admin yum.repos.d] # mv CentOS-Debuginfo.repo CentOS-Debuginfo.repo.bak
至此,用光盘做的yum就可用了;
[root@admin ~]#yum --enablerepo=c6-media install ncurses* gcc* perl* -y
3,准备好安装包. (这里以 mysql-5.0.56.tar.gz举例)
4,添加mysql 用户
[root@admin ~]#groupadd mysql
[root@admin ~]#useradd -g mysql mysql -s /bin/nologin
二,正式安装
1. [root@admin software]#tar zxvf mysql-5.0.56.tar.gz
2. [root@admin software]# cd mysql-5.0.56
3. [root@admin mysql-5.0.56]# ./configure --prefix=/usr/local/mysql --localstatedir=/data/mysql --enable-assembler -- enable-static --with-mysqld-user=mysql --with-big-tables --enable-thread-safe-client -- enable-local-infile --with-charset-utf8 --with-extra-charsets=all
4. [root@admin mysql-5.0.56]# make && make install
5. [root@admin mysql-5.0.56]# cp support-files/my-medium.cnf /etc/my.cnf
6. [root@adim share]# cd /usr/local/mysql/
7. [root@admin mysql]# bin/mysql_install_db --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/local/mysql/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
8. [root@admin mysql]# chown -R mysql.mysql /data/mysql/
9. [root@admin mysql]# share/mysql/mysql.server start
Starting MySQL SUCCESS! #--------------> 看到如此,便知道安装成功了.
10. [root@admin mysql]# netstat -tunlp | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 13193/mysqld
三. 后绪工作
1.[root@admin ~]# ln -s /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
2.[root@admin ~]# ln -s /usr/local/mysql/bin/mysql /usr/sbin/mysql
3.[root@admin ~]# ln -s /usr/local/mysql/bin/mysqladmin /usr/sbin/mysqladmin
4.[root@admin ~]# ln -s /usr/local/mysql/bin/mysqldump /usr/sbin/mysqldump
5.[root@admin ~]# mysql -uroot -p
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 2
Server version: 5.0.56-log Source distribution
Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql>
本文出自 “OpenSource滴天空” 博客
bitsCN.com
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

Solution to the problem that Win11 system cannot install Chinese language pack With the launch of Windows 11 system, many users began to upgrade their operating system to experience new functions and interfaces. However, some users found that they were unable to install the Chinese language pack after upgrading, which troubled their experience. In this article, we will discuss the reasons why Win11 system cannot install the Chinese language pack and provide some solutions to help users solve this problem. Cause Analysis First, let us analyze the inability of Win11 system to

You may not be able to install guest additions to a virtual machine in OracleVirtualBox. When we click on Devices>InstallGuestAdditionsCDImage, it just throws an error as shown below: VirtualBox - Error: Unable to insert virtual disc C: Programming FilesOracleVirtualBoxVBoxGuestAdditions.iso into ubuntu machine In this post we will understand what happens when you What to do when you can't install guest additions in VirtualBox. Unable to install guest additions in VirtualBox If you can't install it in Virtua

If you have successfully downloaded the installation file of Baidu Netdisk, but cannot install it normally, it may be that there is an error in the integrity of the software file or there is a problem with the residual files and registry entries. Let this site take care of it for users. Let’s introduce the analysis of the problem that Baidu Netdisk is successfully downloaded but cannot be installed. Analysis of the problem that Baidu Netdisk downloaded successfully but could not be installed 1. Check the integrity of the installation file: Make sure that the downloaded installation file is complete and not damaged. You can download it again, or try to download the installation file from another trusted source. 2. Turn off anti-virus software and firewall: Some anti-virus software or firewall programs may prevent the installation program from running properly. Try disabling or exiting the anti-virus software and firewall, then re-run the installation

Installing Android applications on Linux has always been a concern for many users. Especially for Linux users who like to use Android applications, it is very important to master how to install Android applications on Linux systems. Although running Android applications directly on Linux is not as simple as on the Android platform, by using emulators or third-party tools, we can still happily enjoy Android applications on Linux. The following will introduce how to install Android applications on Linux systems.

While studying in high school, some students take very clear and accurate notes, taking more notes than others in the same class. For some, note-taking is a hobby, while for others, it is a necessity when they easily forget small information about anything important. Microsoft's NTFS application is particularly useful for students who wish to save important notes beyond regular lectures. In this article, we will describe the installation of Ubuntu applications on Ubuntu24. Updating the Ubuntu System Before installing the Ubuntu installer, on Ubuntu24 we need to ensure that the newly configured system has been updated. We can use the most famous "a" in Ubuntu system

If you have used Docker, you must understand daemons, containers, and their functions. A daemon is a service that runs in the background when a container is already in use in any system. Podman is a free management tool for managing and creating containers without relying on any daemon such as Docker. Therefore, it has advantages in managing containers without the need for long-term backend services. Additionally, Podman does not require root-level permissions to be used. This guide discusses in detail how to install Podman on Ubuntu24. To update the system, we first need to update the system and open the Terminal shell of Ubuntu24. During both installation and upgrade processes, we need to use the command line. a simple

Many novice friends still don’t know how to install creo, so the editor below brings relevant tutorials on creo installation. Friends in need should take a look at it. I hope it can help you. 1. Open the downloaded installation package and find the License folder, as shown in the figure below: 2. Then copy it to the directory on the C drive, as shown in the figure below: 3. Double-click to enter and see if there is a license file, as shown below As shown in the picture: 4. Then copy the license file to this file, as shown in the following picture: 5. In the PROGRAMFILES file of the C drive, create a new PLC folder, as shown in the following picture: 6. Copy the license file as well Click in, as shown in the figure below: 7. Double-click the installation file of the main program. To install, check the box to install new software.

Many users have just downloaded the solidworks2018 software and still don’t know how to install solidworks2018? Next, the editor will bring you a solidworks2018 installation tutorial. Interested users can take a look below. 1. Open the software we downloaded, and then find the _SolidSQUAD_ folder, find the SolidWorks.2017-2018.Activator.SSQ file inside, double-click to open, and then the following interface will appear: click on the first item in turn, the icon item on the right, Finally, click the Accept button below, and the following pop-up window will appear: Click YES, and click OK in the dialog box to continue the pop-up window. 2. Then we click
