Start MySQL with cmd

1) cmd to start MySQL:

Local:

Server:

2) Linux install MySQL locally via rpm

Note: To install is two east, one is a server, a client, it must be installed first server and then installed the client

Install the server:

A package conflict was found and the command to execute the delete package was resolved:rpm-e mysql-libs-5.1.73-5.el6_6.x86_64--nodeps

Remember to reinstall the server after the conflict.

Install the client again:

Several ways to see if it is successful:

port monitoring of network processes in the system :

Firewall:service iptables status;service iptables stop;service iptables start

Services: Service MySQL start;service mysql status;service mysql stop

To see if there are mysq processes:ps-ef | grep mysqld

kill Process:"kill-9 process number"

Formally enter the mysql:mysql-uroot-p123456 (Note: 12345 is your root password AH)

Find files:find-name yum (here Yum stands for the file name you are looking for)

History: Check out the commands you've been knocking on.

PWD: View the path below the current directory

2) Note the number of space bytes occupied

About the two options that were previously ignored:

About unsigned: Where the id tick the fill 0,test_tinyint is not checked

The tool class does not seem to change much:

However, once length, you will find that the length has changed, but it is not shown:

Again through the cmd look:

Also, if in the actual development, know that if it is definitely positive, then, I tick unsigned words, better ah.

END

Start MySQL with cmd