MySql installation and login details
- 2021-07-10 21:04:19
- OfStack
Check whether MySQL is installed on the Linux system
sudo service mysql start // Try to open MySQL Services
Hint:
mysql: unrecongized service // Explain that the system does not have MySQL
You need to
// Installation MySQL Server, core program
sudo apt-get install mysql-server
// Installation MySQL Client
sudo apt-get install mysql-client
Verify sudo netstat-tapgrep mysql (note that netstat is preceded and 1 space is preceded-tap)
Modify configuration file (my. cnf) sudo gedit/etc/mysql/my. cnf
Practiced logging in and exiting MySQL, using and viewing databases
// Start MySQL Services
sudo service mysql start
//
mysql -u root
View the database show databases;
Connection database use database name
View table show tables;
Exit quit or exit