The entire process of installing MySQL in SUSE

Source: Internet
Author: User

Preparations before installation:

Download the server Installation Package (rpm package) and Client installation package:

I use the latest version on the official website:

Server: MySQL-server-5.1.53-1.glibc23.i386.rpm

Client: MySQL-client-5.1.53-1.glibc23.i386.rpm

After both packages are tested locally, go to the installation directory:

My directory is mysql:

XSwap @ linux-p33n :~ /Mysql>

Because my current user does not have the permission to perform the installation operation, you can upgrade the permission of sudo or switch the user. I am in trouble to directly change the user su root your password OK

Now, start to install the server package:

Linux-p33n:/home/xSwap/mysql # rpm-ivh MySQL-server-5.1.53-1.glibc23.i386.rpm
Preparing... ######################################## ### [100%]
1: mySQL-server ##################################### ###### [100%]

Please remember to set a password for the MySQL root USER!
To do so, start the server, then issue the following commands:

/Usr/bin/mysqladmin-u root password 'new-password'
/Usr/bin/mysqladmin-u root-h linux-p33n password 'new-password'

Alternatively you can run:
/Usr/bin/mysql_secure_installation

Which will also give you the option of removing the test
Databases and anonymous user created by default. This is
Stronugly recommended for production servers.

See the manual for more instructions.

Please report any problems with the/usr/bin/mysqlbug script!

Starting MySQL. done

The installation is complete. Check the port to check whether the installation is successful:

Linux-p33n:/home/xSwap/mysql # netstat-nat
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
Tcp 0 0 0.0.0.0: 3306 0.0.0.0: * LISTEN
Tcp 0 0 0.0.0.0: 111 0.0.0.0: * LISTEN
Tcp 0 0 127.0.0.1: 631 0.0.0.0: * LISTEN
Tcp 0 0 127.0.0.1: 25 0.0.0.0: * LISTEN
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48125 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48128 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48123 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48122 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48127 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48130 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48124 TIME_WAIT
Tcp 0 0 127.0.0.1: 3306 127.0.0.1: 48126 TIME_WAIT
Tcp 0 0: 11168: * LISTEN
Tcp 0 0: 9000: * LISTEN
Tcp 0 0: 111: * LISTEN
Tcp 0 0: 1: 631: * LISTEN
Tcp 0 0: 1: 25: * LISTEN
Tcp 0 0 127.0.0.1: 48131 127.0.0.1: 3306 TIME_WAIT
Tcp 1 0 192.9.11.210: 9000 192.9.11.73: 4910 CLOSE_WAIT
Tcp 0 0 192.9.11.210: 59158 192.9.11.180: 55555 ESTABLISHED
Tcp 0 0 127.0.0.1: 48129 127.0.0.1: 3306 TIME_WAIT

I can see the word "3306". Haha, the server package is successfully installed.

Next, the client package:

Linux-p33n:/home/xSwap/mysql # rpm-ivh MySQL-client-5.1.53-1.glibc23.i386.rpm
Preparing... ######################################## ### [100%]
Package MySQL-client-5.1.53-1.glibc23.i386 is already installed

Package MySQL-client-5.1.53-1.glibc23.i386 is already installed

Previously, this package will certainly be prompted, but there will be no prompts for the first installation.

OK. The installation is complete! Of course, the installation was unsuccessful. I did not have to test it:

Linux-p33n:/home/xSwap/mysql # mysql
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 220
Server version: 5.1.53 MySQL Community Server (GPL)

Copyright (c) 2000,201 0, Oracle and/or its affiliates. All rights reserved.
This software comes with absolutely no warranty. This is free software,
And you are welcome to modify and redistribute it under the GPL v2 license

Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.

Mysql>

OK. This is my success!

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.