#myql

[thesnobbyartsyblog]

A pic with me and everybody who hate on this.

[thesnobbyartsyblog]

Lanvin Silk Trousers

[thesnobbyartsyblog]

[crocus25]

[cnnbr-blog]

Crear radio online con html 5 + php + myql + css + jquery

Crear radio online con html 5 + php + myql + css + jquery

[kuntoaji]

[grrrrfuck]

Sorting out MySql

I've never stopped using the root user for mysql on my server, so i felt it was time to create a new user and start using this one instead of root. Also i wanted to update the mysql root password with a better password.

# Log into the server then # Log into mysql

mysql -u root -p

## Create a new user

mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';

## Grant everything to the new guy

mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' WITH GRANT OPTION;

## Check if the user was created via

mysql> select User from mysql.user;

## Exit out of mysql and if you want to change the root password you can do so using this command

mysqladmin -u root -p'oldpassword' password newpass

[coder]