MySQL's ancestor is mSQL. At first the MySQL team tried to use mSQL with their own fast low-level (ISAM) routines. However, after some testing, they came to the conclusion that mSQL was not fast enough or flexible enough for their needs. Then they developed MySQL, which is also why MySQL has almost the same interface as mSQL.
The name MySQL could have come from two sources: The base directory and a large number of libraries and tools have had the prefix my for well over 10 years. Also, the co-founder Monty Widenius's daughter is also named My.
The name of the MySQL Dolphin (our logo) is Sakila suggested by Ambrose Twebaze, an Open Source software developer from Swaziland, Africa. According to Ambrose, the feminine name Sakila has its roots in SiSwati, the local language of Swaziland. Sakila is also the name of a town in Arusha, Tanzania, near Ambrose's country of origin, Uganda. [MySQL] 2 License Different from PostgreSQL, which only has a BSD-style license, MySQL has two different licenses: the commercial license which applies to companies who do not want to follow the GPL license and open their source code, and the GPL license for all others. 3 How do I change root password? If you've never setup password before, use mysqladmin -u root password NEWPASSWORD to set a new password. Otherwise, use mysqladmin -u root -p oldpassword newpass to change password 4 Where is my config file? On linux, it's /etc/my.cnf. 5 I am using mysql+jboss+hibernate, however, I got "Communications link failure" This is because MySQL closes conections after 8 hours of inactivity. [WD] One possible solution is to add after you db url, for example, jdbc:mysql://yoursite.com/yourdb?autoReconnect=true 6 How to grant user access to a specific database GRANT ALL ON dbname.* to 'username'@'%' IDENTIFIED BY 'password' 7 [c3p0] A PooledConnection that has already signalled a Connection error is still in use You have to use either Transaction.commit even if you are only doing a select. [MS] 8 MyIsam vs InnoDB These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table. The other two database engines are Memory and NDB [SE] Comments References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
Different from PostgreSQL, which only has a BSD-style license, MySQL has two different licenses: the commercial license which applies to companies who do not want to follow the GPL license and open their source code, and the GPL license for all others. 3 How do I change root password? If you've never setup password before, use mysqladmin -u root password NEWPASSWORD to set a new password. Otherwise, use mysqladmin -u root -p oldpassword newpass to change password 4 Where is my config file? On linux, it's /etc/my.cnf. 5 I am using mysql+jboss+hibernate, however, I got "Communications link failure" This is because MySQL closes conections after 8 hours of inactivity. [WD] One possible solution is to add after you db url, for example, jdbc:mysql://yoursite.com/yourdb?autoReconnect=true 6 How to grant user access to a specific database GRANT ALL ON dbname.* to 'username'@'%' IDENTIFIED BY 'password' 7 [c3p0] A PooledConnection that has already signalled a Connection error is still in use You have to use either Transaction.commit even if you are only doing a select. [MS] 8 MyIsam vs InnoDB These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table. The other two database engines are Memory and NDB [SE] Comments References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
If you've never setup password before, use
mysqladmin -u root password NEWPASSWORD
mysqladmin -u root -p oldpassword newpass
On linux, it's /etc/my.cnf. 5 I am using mysql+jboss+hibernate, however, I got "Communications link failure" This is because MySQL closes conections after 8 hours of inactivity. [WD] One possible solution is to add after you db url, for example, jdbc:mysql://yoursite.com/yourdb?autoReconnect=true 6 How to grant user access to a specific database GRANT ALL ON dbname.* to 'username'@'%' IDENTIFIED BY 'password' 7 [c3p0] A PooledConnection that has already signalled a Connection error is still in use You have to use either Transaction.commit even if you are only doing a select. [MS] 8 MyIsam vs InnoDB These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table. The other two database engines are Memory and NDB [SE] Comments References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
This is because MySQL closes conections after 8 hours of inactivity. [WD] One possible solution is to add after you db url, for example, jdbc:mysql://yoursite.com/yourdb?autoReconnect=true 6 How to grant user access to a specific database GRANT ALL ON dbname.* to 'username'@'%' IDENTIFIED BY 'password' 7 [c3p0] A PooledConnection that has already signalled a Connection error is still in use You have to use either Transaction.commit even if you are only doing a select. [MS] 8 MyIsam vs InnoDB These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table. The other two database engines are Memory and NDB [SE] Comments References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
GRANT ALL ON dbname.* to 'username'@'%' IDENTIFIED BY 'password' 7 [c3p0] A PooledConnection that has already signalled a Connection error is still in use You have to use either Transaction.commit even if you are only doing a select. [MS] 8 MyIsam vs InnoDB These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table. The other two database engines are Memory and NDB [SE] Comments References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
You have to use either Transaction.commit even if you are only doing a select. [MS] 8 MyIsam vs InnoDB These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table. The other two database engines are Memory and NDB [SE] Comments References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
These are two different mysql database engines, in other words, two ways to store and access mysql data. In general MyIsam is faster and takes less CPU/memory/disk resource, but has less support for transactions and is prone to error in case of system failure (power outage,etc). InnoDB has better support for multi-statement transactions, but is usually slower. For sql queries with a lot of locks, innoDB may be a better choice because it locks by row instead of table.
The other two database engines are Memory and NDB [SE]
References[MS] http://www.mikeschubert.com/archives/programming/[MySQL] website[SE] http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html[WD] http://www.webdeveloper.com/forum/showthread.php?t=97823
