The following sums how to create a new database and give a user appropriate rights via the mysql command line client:
For instance when accessing a server using MySQL Query Browser you need to enable remote access, or you'll receive errors 1130 or 2003.
to restart mysql on Debian / Ubuntu:
assuming the table is named pet
In MySQL you can retrieve the value of the last auto increment field upped by an insert using the LAST_INSERT_ID() function. Example: