/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h myhost password ‘new-password’
mysql -p -u root
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h myhost password ‘new-password’
mysql -p -u root
phpRPG is an open source project established since 2001. The aim of the project is to develop a web-based RPG (role-playing game) using a powerful server-side scripting engine called PHP and its best known open source database companion MySQL.
very simple CMS system build by php. it provides support for mysql database, but not support template.
export and import mysql database in command line
export
mysqldump -u admin_user -p database_name > file.sql
import
mysql -u admin_user -p database_name < file.sql
tutorial for using Google App Engine connect mysql server.
I have enabled mysql service in vps server. but I hate it. this service use more than 64MB memory!!!
fails to connect remote mysql server, I think mysql server port 3306 has been blocked by DIT firewall.