随笔分类 -  MySQL

摘要:$ mysql -u rootmysql>use mysql;mysql>updateuserset password=PASSWORD("NEWPASSWORD")whereUser='root';mysql> flush privileges;mysql> quit 阅读全文
posted @ 2013-12-06 00:18 lei1016cn 阅读(372) 评论(0) 推荐(0)
摘要:I have installed Apache, PHP, and MySQL on Mac OS X since Leopard. Each time doing so by hand. Each version of Mac OS X having some minor difference. This post serves as much for my own record as to outline how to install Apache, MySQL, and PHP for a local development environment on Mac OS X Mountai 阅读全文
posted @ 2013-12-06 00:16 lei1016cn 阅读(809) 评论(0) 推荐(0)
摘要:Dump ALL MySQL Databases mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL Dump Individual or Multiple MySQL Databases mysqldump --user=XXXXXXXX --password=XXXXXXX --database... 阅读全文
posted @ 2010-10-10 23:07 lei1016cn 阅读(470) 评论(0) 推荐(0)