Install MySQL in Ubuntu and unzip tumysql
Enter sudo apt-get install mysql-server mysql-client on the terminal
During the installation process, you will be asked to enter the password of the root user (the user managing the MySQL database, not the user of the Linux system) and enter the password as required.
Enter mysql-uroot-p on the terminal and then prompt you to enter the correct password.
Some simple MySQL management:
Start MySQL service: sudo start mysql
Stop MySQL service: sudo stop mysql
Modify the MySQL administrator password: sudo mysqladmin-u root password newpassword
Set Remote Access (normally, mysql only listens to port 3306 on IP 127.0.0.1, and denies access from other IP addresses (which can be viewed through netstat ). Cancel local monitoring
Modify the my. cnf file as follows :):
Sudo vi/etc/mysql/my. cnf
Bind-address = 127.0.0.1 // locate this content and comment
Directory structure analysis (this structure is only applicable to online installation using apt-get install ):
Database storage directory:/var/lib/mysql/
Related configuration file storage directory:/usr/share/mysql
Related command storage directory:/usr/bin (mysqladmin mysqldump and other commands)
Startup step storage directory:/etc/rc. d/init. d/
MySQL graphical management software:
Generally, two of them are better, one is open source, and the other is charged for commercial usage:
Open-source: MySQL Workbench
Business: Navicat