Tag: MySQL

I don’t know how many times I have forgotten passwords, you would think I would learn to keep them safe somewhere. Well, if you are forgetful like me, here is how to reset the root password of mysql. #/etc/init.d/mysql stop #mysqld_safe –skip-grant-tables & #mysql -u root mysql> use mysql; mysql> update user set password=PASSWORD(“newpass”) where …

Continue reading

The following is a quick example on how to create a database in mysql.  You would type secctions in blue. #mysql -u root -p Enter password: Create a DB called blogger1 mysql> create database blogger1; Allow user ‘xyz’ with password ‘xyzpassword’ access to server mysql> grant usage on *.* to xyz@localhost identified by ‘xyzpassword’; Allow …

Continue reading