Install MySQL notebook under Linux

Source: Internet
Author: User
Tags gz file mysql text touch

Install MySQL

Download mysql-standard-4.1.8-pc-linux-i686.tar.gz file to directory/usr/local/

# Groupadd MySQL//add MySQL user group

# useradd-g MySQL mysql//in MySQL user to MySQL user group

# TAR–ZXVF mysql-standard-4.1.8-pc-linux-i686.tar.gz//Unzip the installation package

# rm–f mysql-standard-4.1.8-pc-linux-i686.tar.gz//Delete compressed package

# mv mysql-standard-4.1.8-pc-linux-i686 MySQL//Put files in mysql-standard-4.1.8-pc-linux-i686 into MySQL text Folders, and delete the mysql-standard-4.1.8-pc-linux-i686 folder

# CD MySQL//go to MySQL folder

# CP/USR/LOCAL/MYSQL/SUPPORT-FILES/MY-MEDIUM.CNF/ETC/MY.CNF//Copy the configuration file to/etc/under Rename to My.cnf, at this time Prompt to overwrite duplicate file, answer Y

# scripts/mysql_install_db--user=mysql//with MySQL user initialized database, must be with MySQL user

# Chown-r Root. Note that the following is a bit, which indicates that the owner of all files and subdirectories under the current directory is set to the root user

# chown-r MySQL Data//indicates that the owner of the data directory under the current directory is set as a MySQL user

# chgrp-r MySQL. Note that the following is a bit, which indicates that the file group for the file under the current directory is set to the MySQL group

# Bin/mysqld_safe--user=root &//& Show background start

At this point, if "... ended" is not displayed, the boot succeeds. Enter to display the command input line.

To see if MySQL starts:

# Ps-aux | grep mysqld

You will see information similar to the following:

Root 14105 0.0 0.0 3896 660 pts/0 s+ 08:50 0:00 grep mysqld

Root 14304 0.0 0.0 4452 1092? S Apr24 0:00/bin/sh./mysqld_safe--user=mysql

MySQL 14327 0.0 0.7 41024 14508? S Apr24 0:01/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysql--pi D-file=/usr/local/mysql/data/localhost.localdomain.pid--skip-locking--port=3306--socket=/tmp/mysql.sock

MySQL 14328 0.0 0.7 41024 14508? S Apr24 0:01/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysql--pi D-file=/usr/local/mysql/data/localhost.localdomain.pid--skip-locking--port=3306--socket=/tmp/mysql.sock

MySQL 14329 0.0 0.7 41024 14508? S Apr24 0:00/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysql--pi D-file=/usr/local/mysql/data/localhost.localdomain.pid--skip-locking--port=3306--socket=/tmp/mysql.sock

To see if MySQL is listening on the port:

# Netstat-tl | grep MySQL

You'll see something like this:

TCP 0 0 *:mysql *:* LISTEN

Errors that may occur:

Can ' t connect to local MYSQL server through socket '/tmp/mysql.sock ' at this time ensure that the "socket" profile in/ETC/MY.CNF is present

such as:/etc/my.cnf in Socket=/tmp/mysql.sock in/tmp/must have Mysql.sock file if not then # Touch/tmp/mysql.sock//build Mysql.sock file

Can ' t create/write to file '/usr/local/mysql/data/localhost.localdomain.pid ' has this kind of error occurred, View permissions issues and whether localhost.localdomain.pid files exist

Set permissions command: # chown–r Create File command: # Touch

Can ' t create/write to file '/usr/local/mysql/data/localhost.localdomain.pid ' error may also occur when MySQL is started and no stop service is started again

Uninstall MySQL

# rpm-qa|grep-i MySQL

The following information may appear:

mysql-server-4.1.8-0

mysql-client-4.1.8-0

Occurs then executes:

# Rpm-ev mysql-server-4.1.8-0 mysql-client-4.1.8-0

Then manually delete the/usr/local/mysql folder and configuration files, etc.

# Rm–rf/usr/local/mysql

# rm-f/ETC/MY.CNF

Install MySQL notebook under Linux

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.