Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Tuesday, January 24, 2012

How to reset MySQL password

Stop the mysql demon process using this command :
sudo /etc/init.d/mysql stop

Start the mysqld demon process using following command
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

mysql -u root

The following command will allow to change the password
FLUSH PRIVILEGES;

Update the password
SET PASSWORD FOR root@'localhost' = PASSWORD('password');

More details available here

Monday, January 23, 2012

How to solve "XAMPP: Another MySQL daemon is already running. "

Use the Following command

sudo /etc/init.d/mysql stop






How to solve XAMPP: Another web server daemon is already running.

Use the following command to solve the issue 


sudo /etc/init.d/apache2 stop

How to install XAMP in Ubuntu

The xamp has Apache web server, MySQL, php, and perl. XAMP is available for ubuntu, windows, mac
XAMP was previously called LAMP.

Following steps will guide you to install XAMP

Using Zotero for academic writing