ubuntu14.04 installing MySQL

Start installing MySQL today. Originally to the official website to download the installation package installation, but not used after installation, is expected to configure, search the Internet very much information, the result or failure.

So just install in the software source, so you save a lot of unnecessary trouble.

[Email protected]:~$ sudo apt-get install Mysql-server[sudo] password for Zhiniaobu:

After running the command, the system will also proactively install some other software. You will be prompted to enter MySQL login password during the installation process.

Assume that the system version number is not the same. The hints may not be the same, but the whole thing is almost the same.

Once installed, run the command

The result was wrong, Google took half a day. The result is more and more impatient, this time turned over the books they bought, entered the following command

[Email protected]:~$ mysql-uroot-pmysql

Of The first one MySQLis an order, -urootis the specified user as root, -pmysqlis the input login password, the second MySQL is password, assuming you set the password is something else, you can set the password when you install. Remember Password and-pBetween do not have spaces, or it will fail.

The following is my successful login to view the currently existing database.

[Email protected]:~$ mysql-uroot-pmysqlwelcome to the MySQL monitor.  Commands End With; or \g.your MySQL connection ID is 61Server version:5.5.37-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) #, Oracle and/o R its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema | | mysql              

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

ubuntu14.04 installing MySQL