MySQL - Revision history

Andrew at 10:53, 13 March 2023

2023-03-13T10:53:11Z

Andrew: /* Getting rid of /var/log/mysql.* */

2010-02-19T18:04:55Z

‎Getting rid of /var/log/mysql.*

Andrew: /* Getting rid of /var/log/mysql.* */

2010-02-19T18:03:23Z

‎Getting rid of /var/log/mysql.*

Andrew at 18:02, 19 February 2010

2010-02-19T18:02:11Z

Andrew at 21:26, 3 February 2010

2010-02-03T21:26:37Z

Andrew at 20:30, 27 January 2010

2010-01-27T20:30:06Z

Admin at 19:47, 8 December 2009

2009-12-08T19:47:18Z

Admin: 2 revision(s)

2007-11-03T18:03:03Z

2 revision(s)

Andrew at 16:25, 22 June 2006

2006-06-22T16:25:15Z

Andrew at 16:23, 22 June 2006

2006-06-22T16:23:59Z

New page

== Assigning passwords to users ==
Login to mysql as the relevant user and run:
<pre>
SET PASSWORD = PASSWORD('biscuit');
</pre>

== Creating new users ==
Login to mysql as root, and run:
<pre>
GRANT ALL ON database.* TO myuser@localhost IDENTIFIED BY 'password';
</pre>
Or, to create a user with no password:
<pre>
GRANT ALL ON database.* TO myuser@localhost;
</pre>
Obviously, different privileges can be assigned to databases and tables. To revoke privileges, the syntax is:
<pre>
REVOKE ALL ON database.* FROM myuser@localhost;
</pre>

← Older revision		Revision as of 10:53, 13 March 2023
Line 1:		Line 1:
		+	== Logging in and switching to a DB ==
		+	<pre>
		+	sudo mysql
		+	show databases;
		+	use <db>;
		+	show tables;
		+	</pre>
		+
	== Assigning passwords to users ==		== Assigning passwords to users ==
	Login to mysql as the relevant user and run:		Login to mysql as the relevant user and run:

← Older revision		Revision as of 18:04, 19 February 2010
Line 50:		Line 50:

	== Getting rid of /var/log/mysql.* ==		== Getting rid of /var/log/mysql.* ==
−	These files never get written to, but apparmor creates them anyway. Comment out the appropriate lines in ''/etc/apparmor.d/usr.sbin.mysqld''. ''Does this work?''	+	These files never get written to, but apparmor creates them anyway. Comment out the appropriate lines in ''/etc/apparmor.d/usr.sbin.mysqld''. ''Does this work, or can we simply delete them and they'll disappear forever?''

← Older revision		Revision as of 18:03, 19 February 2010
Line 50:		Line 50:

	== Getting rid of /var/log/mysql.* ==		== Getting rid of /var/log/mysql.* ==
−	These files never get written to, but apparmor creates them anyway. Comment out the appropriate lines in ''/etc/apparmor.d/usr.sbin.mysqld''.	+	These files never get written to, but apparmor creates them anyway. Comment out the appropriate lines in ''/etc/apparmor.d/usr.sbin.mysqld''. ''Does this work?''

← Older revision		Revision as of 18:02, 19 February 2010
Line 44:		Line 44:
	cat file.sql \| mysql <db_name> -u root -p		cat file.sql \| mysql <db_name> -u root -p
	</pre>		</pre>
		+
		+	== Investigating problems ==
		+	* '''mytop --prompt''' will show long-running/large queries
		+	* Turn logging on in ''/etc/mysql/my.cnf'' to trace all queries (though this will slow the server down)
		+
		+	== Getting rid of /var/log/mysql.* ==
		+	These files never get written to, but apparmor creates them anyway. Comment out the appropriate lines in ''/etc/apparmor.d/usr.sbin.mysqld''.

@@ Line 32: / Line 32: @@
 <pre>
 sudo find /var/lib/mysql -name *.MYI -exec myisamchk -r {} \;
 </pre>

@@ Line 22: / Line 22: @@
 <pre>
 REVOKE ALL ON database.* FROM myuser@localhost;
 </pre>

← Older revision	Revision as of 18:03, 3 November 2007
(No difference)

@@ Line 13: / Line 13: @@
 <pre>
 GRANT ALL ON database.* TO myuser@localhost;
 </pre>
 Obviously, different privileges can be assigned to databases and tables. To revoke privileges, the syntax is: