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;