Coding, Linux, Hacking Security, Learning!
mysql
how to delete database
May 23rd
login to your database
>mysql -u user_name -p
>drop database old_database;
here is the command to create new database
>create database mynewdb;
How to create root user password in MySql
Aug 2nd
1) kill your mysqld
2) mysqld_safe –skip-grant-table
3) login as: mysql –user=root mysql
4) update mysql.user set password=PASSWORD(‘new-pass’) WHERE User=’root’;
5) flush privileges;
6) exit;
you are done!
How to add new user in MySql
Oct 7th
