Admin at 00:17, 16 March 2015

2015-03-16T00:17:33Z

← Older revision		Revision as of 00:17, 16 March 2015
Line 55:		Line 55:
	sudo service mysql start		sudo service mysql start
	</pre>		</pre>

			[[Category:Ubuntu]]

Admin: Created page with "=Admin= The stock Ubuntu version of MySQL is running on port 3306. The binary is `/usr/bin/mysql`. The configuration is in `/etc/mysql/my.cnf`. The data..."

2015-03-16T00:17:12Z

Created page with "=Admin= The stock Ubuntu version of MySQL is running on port 3306. The binary is <code>/usr/bin/mysql</code>. The configuration is in <code>/etc/mysql/my.cnf</code>. The data..."

New page

=Admin=

The stock Ubuntu version of MySQL is running on port 3306.

The binary is <code>/usr/bin/mysql</code>.

The configuration is in <code>/etc/mysql/my.cnf</code>.

The database data itself is stored in <code>/var/lib/mysql</code>.

==Resetting Password==

More info here: https://help.ubuntu.com/community/MysqlPasswordReset

To reset the admin password, first stop the mysql service:

<pre>
sudo service mysql stop
</pre>

Next, start mysql with the skip-grant-tables option so that it doesn't worry about authenticating users:

<pre>
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
</pre>

Now start mysql as the root user:

<pre>
mysql -u root
</pre>

Now execute the following commands in MySQL, one line at a time:

<pre>
FLUSH PRIVILEGES;
</pre>

<pre>
SET PASSWORD FOR root@'localhost' = PASSWORD('password');
</pre>

(alt? <code>UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';</code> - in case you have root account that can connect from anywhere)

<pre>
FLUSH PRIVILEGES;
</pre>

Now you can type "exit" and get back to a regular command line.

Stop and start the MySQL service:

<pre>
sudo service mysql stop # <-- not really necessary
sudo service mysql start
</pre>

Ubuntu MySQL - Revision history

Admin at 00:17, 16 March 2015

Admin: Created page with "=Admin= The stock Ubuntu version of MySQL is running on port 3306. The binary is /usr/bin/mysql. The configuration is in /etc/mysql/my.cnf. The data..."

Admin: Created page with "=Admin= The stock Ubuntu version of MySQL is running on port 3306. The binary is `/usr/bin/mysql`. The configuration is in `/etc/mysql/my.cnf`. The data..."