Skip to main content

01.Installing and configuring Mysql

Installing mysql is pretty much simple

for installing in ubuntu use:

sudo apt-get install mysql-server

When installation about to complete mysql ask's for to set root user password,then set it and finish the installation.

First enter in to your root account by command in your terminal

mysql -u root -p, then enter password.In the root terminal type this command to create new user.
CREATE USER 'user_name'@'your_host' IDENTIFIED BY 'your_password';
 
example:CREATE USER 'jerin'@'localhost' IDENTIFIED BY 'password'; 
 
Next is to grant all privileges to use available commands in Mysql

GRANT ALL PRIVILEGES ON * . * TO 'user_name'@'your_host';
 
example: GRANT ALL PRIVILEGES ON * . * TO 'jerin'@'localhost'; 
 
Atlast reload the mysql setting by using 
 


FLUSH PRIVILEGES;
 

Comments

Popular posts from this blog

creating first go program

for creating go program open your editor and paste this code, and save it as filename.go for example helloworld.go

package main import "fmt" func main() { fmt.Println("Hello, 世界") }
I will explain these codes in details for now , we will look how to run these code.

to run type go run helloworld.go  in terminal , we get


you can try golang online as well , golang