MySql Client : The mysql-client package allows you to connect to a MySQL server. It will give you the "mysql" command-line program.
MySql Server : The mysql-server package allows to run a MySQL server which can host multiple databases and process queries on those databases.
sudo apt update
sudo apt upgrade
sudo apt install mysql-server
sudo apt install mysql-client
mysql_secure_installation
systemctl status mysql.service
mysqladmin -p -u root version
mysql -p -u root
sudo systemctl start mysql
sudo systemctl restart mysql
create database cp_intrafish;
sudo apt-get install libmysqlclient-dev
Load Database dump to the newly created database. Here cp_intrafish
is the database name and myifm_dump.sql
is the SQL dump file.
mysql -p -u root cp_intrafish<myifm_dump.sql
Pretty output in MySQL console. Add \G
at the end of your command. This will change the output just for that command, without changing the default output.
SELECT * FROM product_price\G;
Thank you for your service