# The following means mysql is not running:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
MySQL
INSTALL
sudo apt install -y libmysqlclient-dev mysql-client mysql-server
START
$ sudo service mysql start
SETUP
CREATE USER zaphod;
ALTER USER 'zaphod'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'zaphod'@'%'; -- makes zaphod an admin
FLUSH PRIVILEGES;
ACCESS
$ mysql -u zaphod -D some_db -p
ADMIN ACCESS
$ sudo mysql
PostgreSQL
INSTALL
sudo apt install -y postgresql libpq-dev
START
$ sudo service postgresql start
SETUP
create user zaphod;
\password zaphod
create database some_db;
grant all privileges on database some_db to zaphod;
ACCESS
$ psql -U zaphod -h localhost -d some_db
# specifying the host forces md5 (password) authentication. Otherwise default is "peer"
ADMIN ACCESS
$ sudo su postgres
$ psql
Posts
