ubuntu14.04 installing MySQL

today started to install MySQL, originally to the official website to download the installation package to install, but after installation but can not use, is expected to configure it, 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, during the installation process will be prompted to enter the MySQL login password.

Assuming the system version number is different, the hint may not be the same, but the whole thing is almost the same. Once installed, run the command

results error, Google a half-day, the results more and more impatient, this time turned over their own books bought, entered the following command

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

the first MySQL is the command, -uroot is the specified user as root, -pmysql is the input login password, the second MySQL is password, If you set the password is something else, instead of the password you set when you installed, remember that there is no space between password and-p , 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              

ubuntu14.04 installing MySQL