Configuring MySQL and MySQL initialization under Linux

Source: Internet
Author: User
Tags mysql version

The following is the message that prompts after normal initialization, this article is very important

[Email protected] scripts]#/mysql_install_db--basedir=/application/mysql--datadir=/application/mysql/data/-- User=mysql

# #指定mysql安装路径, specify the Data folder, specify user initialization

Warning:the host ' DataServer ' could not being looked up with RESOLVEIP.

Warning: You cannot use RESOLEIP to find a data table for a host.

This probably means that your libc libraries is not compatible

This may mean that your libc library is not 100% compatible with this binary MySQL version.

With this binary MySQL version. The MySQL daemon, mysqld, should work

MySQL Daemon mysqld should work

Normally with the exception that host name resolving won't work.

Typically, host name resolution does not work.

This means, should use IP addresses instead of hostnames

This means that you should use an IP address instead of a host name

When specifying MySQL privileges!

When specifying MySQL privileges!

Installing MySQL system tables ...

Ok

Filling Help Tables ...

Ok


To start mysqld at boot time with to copy

Support-files/mysql.server to the right place for your system

To start mysqld at startup, you must copy

Support File/MySQL. Server to the correct location on your system

REMEMBER to SET A PASSWORD for the MySQL root USER!

To does so, start the server, then issue the following commands:

Please remember to set the password for MySQL root user!

To do this, start the server, and then issue the following command:

/application/mysql/bin/mysqladmin-u root password ' new-password '

/application/mysql/bin/mysqladmin-u root-h dataserver password ' new-password '


Alternatively you can run:

/application/mysql/bin/mysql_secure_installation


Which would also give you the option of removing the test

Databases and anonymous user created by default. This is

Strongly recommended for production servers.

This also allows you to choose to cancel the test

Databases and anonymous users are created by default. This is

Production servers are highly recommended.

See the Manual for more instructions.

Please refer to the manual for more instructions.

You can start the MySQL daemon with:

Cd/application/mysql; /application/mysql/bin/mysqld_safe &


You can test the MySQL daemon with mysql-test-run.pl

Cd/application/mysql/mysql-test; Perl mysql-test-run.pl


Problems with The/application/mysql/scripts/mysqlbug script!


This article is from the "Dongliqiang" blog, make sure to keep this source http://6207422.blog.51cto.com/6197422/1967955

Configuring MySQL and MySQL initialization under Linux

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.