Monthly Archives: October 2013

mysql

Posted on October 29th, 2013

Backup Mysql Database: you can use mysqldump to backup a database. If i want to backup the database mileage into the sql file mileage.sql. $mysqldump -u root -p mileage > mileage.sql You will be prompted to enter the password for the root. This will dump the data and the commands to create the table in […]

Posted in mysql

PHP Mail and Gmail

Posted on October 18th, 2013

I used to run my own mail server from my linux machine. Then due to FCC guidelines, comcast blocked the port for the smtp and pop mail, this way i cannot send or receive emails through that linux server. The other option is enable secure ports for the smtp and the pop and get somebody […]

Posted in Uncategorized

mysql change password

Posted on October 17th, 2013

There are a couple of ways to change a user password including root for the mysql databases. one is using mysqladmin(which i’m not that fluent with) the other is directly go into mysql and change the password. $mysql -u root – p Now enter password (your old password for root) mysql > use mysql; mysql> […]

Posted in mysql