Mysql Quick Entry and Common Commands on Linux
1. Command to log in to mysql
mysql -haddress -uuser -ppassword
-h followed by ip< Br>
-u is followed by the username
-p followed by the password
example :
mysql -h127.0.0.1 -uroot -p123456
mysql -uroot -p
Enter the local database, enter the password after the carriage return
2, enter a database
use databasename;
Use is followed by the database name
For example, the user has the database nserver and clear two databases
show databases;–>View database
use Nserver; –>Enter nserver library
show tables; –>View Table
As the website runs, the MySQL database is getting bigger and bigger, and the backup proble
using direct-lvm storage method Recently played docker on Bluemix virtual machine, but found that t
For all organizations and companies, data is the most important to them, and even for e-com
Alibaba Cloud host has been a very good choice for domestic small webmasters, not only mature techno
Computer technology: linux remote desktop connection
Set the permissions of multiple groups on a file under linux (setfaclgetfacl) method - management
How to run the process in Linux
Linux view directory size and hard disk size
Ubuntu installed Sogou Chinese input method
The small knowledge points used in the Linux system accumulate
Linux command learning - netstat
Explain how to configure Win 2003 servers
Win7 open iTunes pops up "bonjour service has been disabled" how to deal with?
"Light of Torch" opens vertical sync method under Windows 7
After the Vista update, the program can not be uninstalled. Reference
Win7 system installation software prompt is not a valid win32 application solution
System acceleration starts from step-by-step optimization of XP system (2)
How to properly set up WinXP virtual memory
Two ways to use genuine Win10 detailed graphic guide free of charge
Do not let Win8.1 RTM install Bing input method
Family Safety: Parental Control or “Parents are Controlled” (1)