Archive · February 23, 2010

mysql ubuntu help

MySQL find all instances of mysql: ps -aux | grep mysql stop MySQL /etc/init.d/mysql stop skip grant tables: mysqld_safe ?skip-grant-tables & remove mysql: apt-get --purge remove mysql-client mysql-server login: mysql -u -p example: mysql -u root -p change password: http://www.mydigitallife.info/2006/06/06/change-and-reset-mysql-root-password/ update mysql.user set password=password('XXXXX') where user='admin'; DEFAULT PASS SHOULD BE SETUP!!! update mysql.user set password=password('setup') where user='admin'; update mysql.user set password=password('') where user='root'; flush privs: FLUSH PRIVILEGES;