Op3r

Yep there was a time in our sleep deprived environment that we need to create a user for our ultra secured mysql server. He wants a GRANT ALL permission on a new database. So you’re googling the internet because you are lazy and found my site. I don’t want hearing the “You disappoint son” verbiage so here’s how.

So we will create a database called CRM. *note we will be using a vicidialNOW uhm goautodial VICIDIAL auto install.

[root@vici ~]# mysql -uroot -pvicidialnow

Now you’ll see this
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1474214
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Then you need to type this command
CREATE DATABASE `crm` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

You’ll see this output

mysql> CREATE DATABASE `crm` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Query OK, 1 row affected (0.08 sec)

Congratulations! you just created a new mysql database!

Now let’s create a user with a GRANT ALL privileges to that new mysql database.

For a user with local access capability :

mysql> GRANT all on crm.* TO USERNAME@localhost IDENTIFIED BY 'iphone1234';
Query OK, 0 rows affected (0.02 sec)

with accessing the database outside the mysql server

mysql> GRANT all on crm.* TO USERNAME@'%' IDENTIFIED BY 'iphone1234';
Query OK, 0 rows affected (0.00 sec)

Nope you’re not done yet because no matter what you’ll do you can’t still use the log-in info you created. You need the flush the toilet errr sorry! flush the privileges rather.

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Now you’re done. Hit the comment page if you need to ask some question about the said how to.