apt-get install mysql-client-core-5.6
apt-get install mysql-client-5.6
apt-get install mysql-server-5.6

create database test default charset=utf8;
grant all on test.* to 'test'@'192.168.137.%' identified by 'test';
flush privileges;

Connection error
ERROR 2003 (HY000): Can't connect to MySQL server on

vim /etc/mysql/my.cnf
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1  <--- Comment out this line and you can log in remotely

/etc/init.d/mysql reload

Ubunt install mysql More articles about

  1. Centos6.5 Download and install mysql 5.6

    One : Uninstall old version Use the following command to check if the MySQL Server rpm -qa | grep mysql If there is one, unload it with the following command rpm -e mysql // Normal delete mode rpm -e ...

  2. stay Ubuntu 16.10 install mysql workbench The software package is not installed libpng12-0 error

    1. install mysql workbench, Prompt that the package is not installed libpng12-0 Downloaded MySQL Workbench 6.3.8   Error during installation : -1ubu1604-amd64.deb Tips : ...

  3. ubuntu install mysql

    Better a good memory than a bad pen , Make a note of ,ubuntu install mysql Instructions . install MySQL: sudo apt-get install mysql-server sudo apt-get install mysq ...

  4. Linux1 stay Linux(CentOS) Installation on MySql Record in detail

    Preface :   Two years after graduation , I changed my job two days ago , From the traditional industry to the Internet industry . Previous companies have been using WinServer2003+Tomcat+SqlServer/Oracle This deployment environment . about Linux+To ...

  5. PHP install mysql.so Expand

    stay PHP in mysql_connect Modules have been phased out , I didn't install it when I built the environment mysql Expand , But today when it comes to maintaining an old project , There is an error Fatal error: Uncaught Error: Cal ...

  6. install MySql for Visual Studio The pit of

    Read the directory Problem description To solve the process Solution summary Back to the top Problem description install MySql for Visual Studio Generally speaking, in order to be able to VS You can select from the data source of the server data connection MySql type , Here's the picture : but ...

  7. CentOS 7 install MySQL 5.6 Summary of difficult and miscellaneous diseases encountered

    On a test server (CentOS Linux release 7.2.1511) Installation on MySQL 5.6(5.6.19 MySQL Community Server) I encountered the following error when I was reading , This is because CentOS ...

  8. Mac Installation on MySQL Record

    Download the latest MySQL Community Edition Official download address :http://dev.mysql.com/downloads/mysql/ For easier installation , Recommended download dmg Installation package . The latest version is 5.7.9. install MySQL ...

  9. linux install mysql database ——yum Installation method

    mysql There are many ways to install a database , This article only introduces in Linux The most practical on the server . The quickest mysql server Installation method . One .Linux The server yum install (CentOS6.3 64 position ) All commands executed on the server , ...

Random recommendation

  1. .dtsi .dts dtc dtb What is it?

    Basics .dts: device tree source .dtsi:   device tree source include .dts Compare to source files ,.dtsi Compare it to a header file . dtc yes linux Source code /s ...

  2. How to start app Full screen display Default.png( picture )?

  3. JDBC Detailed explanation

    One . Relevant concepts 1. What is? JDBC JDBC(Java Data Base Connectivity,java Database connection ) It's one for execution SQL Of the statement Java API, It can provide unified access for a variety of relational databases , it ...

  4. vue-route+webpack Deploy a single page routing project , Access refresh appears 404 problem

    Problem description : Front end colleagues use Vue.js frame , utilize vue-route combination webpack Write a single page routing project , Operation and maintenance assist in server configuration nginx. After deployment , No problem visiting the home page , It's OK to open the secondary page from the home page , But the ...

  5. wikioi 1083 Cantor surface

    Title Description  Description One of the famous proofs of modern mathematics is Georg Cantor It is proved that rational numbers are enumerable . He uses the following table to prove the proposition : 1/1 1/2 1/3 1/4 1/5 - 2/1 2/ ...

  6. 《Cocos2d-x actual combat Tool volume 》 launched

    Thank you for your support ! All the big stores are selling : JD.COM :http://item.jd.com/11659696.html Dangdang :http://product.dangdang.com/23659809.ht ...

  7. MySQL Row-level locks , Table lock , Page level lock details

    Page level : engine BDB. Table level : engine MyISAM , Lock the whole watch , You can read it at the same time , I can't write Row level : engine INNODB , A single row of records is locked Table level , Lock the whole table directly , While you're locked in , Other processes cannot write to the table ...

  8. Today, let's talk about Java Cast of reference type

    In fact, basic types also have casts , Let's just mention it here . Generally speaking, there are two kinds : 1. Automatic type conversion , It's also called implicit type conversion , That is to say, the small data range is converted into the large data range , The compiler does the type conversion automatically , There's no need for us to write code 2. Type of enforcement ...

  9. JAVA Difference between value type and reference type

    java What are the two data types ? java There are two types of data in : Value type ( Basic data type ) And reference types ( Composite data type )  One : Value type : Integer types (byte,short,int,long)      Floating point class ...

  10. js Code tricks

    1.js It's not a common method to deal with // integer parseInt(a,10); //Before Math.floor(a); //Before a>>0; //Before ~~a; //Aft ...