A mini golang project for demonstrating the CRUD operations of a book management system. The project reproduces the app created by Mr. Akhil Sharma based on his online tutorial.
- Install MYSQL locally with the following commands.
sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation
sudo mysql
mysql -u root -p
mysql -u sammy -p
systemctl status mysql.service
sudo mysqladmin -p -u sammy version
-
Start mysql by running
sudo mysql. -
Create a database for this project, which can be named as "sandbox".
create database sandbox;
- Create a user for using MySQL.
CREATE USER 'mysqluser'@'localhost' IDENTIFIED BY 'mysqlpwd';
- Grant privileges to the user.
GRANT ALL PRIVILEGES ON * . * TO 'mysqluser'@'localhost';
FLUSH PRIVILEGES;
- Verify the existence of the created user.
select Host, User from mysql.user;
-
Exit mysql.
-
To fix the MySQL error: "Resolving the 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Error" https://phoenixnap.com/kb/mysql-server-through-socket-var-run-mysqld-mysqld-sock-2
- Check the status of the MySQL service with
sudo systemctl status mysql - If the service is not running, restart with
sudo systemctl start mysql