PROGRAMMING
Php
Install MySQL
Install
sudo apt install mysql-server
sudo systemctl status mysql
sudo mysql -u root -p (no password)
OR
sudo mysql
show databases;
use mysql;
show tables;
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
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
Install MySQL Workbench
apt install mysql-workbench
admin, password
// Incompatible/nonstandard server version or connection ....
// Continue Anyway
➥ Questions
05 . MySQL
Last update: 11-09-2021
