PROGRAMMING

MINTE9
REMEMBERS




Install MySQL

Install
 
sudo apt install mysql-server
sudo systemctl status mysql
Connection
 
sudo mysql -u root -p (no password)
    OR
sudo mysql

show databases;
    use mysql;
    show tables;    
When root blank password doesn't work.
 
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
Uninstall Mysql    (2/3)

Uninstall MySQL

 
sudo apt-get remove --purge mysql*

sudo apt update     # update the apt package index by typing

sudo apt autoremove    # remove packages not longer required
Mysql Client    (3/3)

MySQL client

Install MySQL Workbench
 
apt install mysql-workbench
Localhost connection
 
admin, password
Connect to remote database
 
// Incompatible/nonstandard server version or connection ....
// Continue Anyway

Questions    
6. Ftp
05 . MySQL
Last update:   11-09-2021

        A B C D E F
🔔
1/4