MySQL Reference

MySQL Creating new user for a database via command line client

The following sums how to create a new database and give a user appropriate rights via the mysql command line client:

MySQL Enable remote access on MySQL

For instance when accessing a server using MySQL Query Browser you need to enable remote access, or you'll receive errors 1130 or 2003.

MySQL Restart MySQL

to restart mysql on Debian / Ubuntu:

MySQL Retrieving table information

assuming the table is named  pet

MySQL MySQL last insert id

In MySQL you can retrieve the value of the last auto increment field upped by an insert using the LAST_INSERT_ID() function. Example:

[x]
Go