If you experience com.mysql.jdbc.PacketTooBigException exception when querying MySQL, it hints that the packet size of your requesting is smaller than the current packet size in MySQL server setting. To increase the packet size, you can set bigger value to max_allowed_packet.… Continue Reading
We may have to modify the table column definition in MySQL database. The syntax is The segment xxx…xxx represents the column definition of the column. Example. If I have a column definition BOOLEAN NOT NULL DEFAULT FALSE COMMENT ‘Abc’ and… Continue Reading
Linux command to start MySQL server.(Login as root) Linux command to shutdown MySQL server.(Login as root)
Here I list some info for installing MySQL server Version: GA 5.5.30 Community Server MySQL provides couple ways in installing the server system. Windows Linux generic binary package Linux RPM OS X Download following modules http://dev.mysql.com/downloads/mysql/5.5.html MySQL Server Client Utility(optional)… Continue Reading
SQL Command Dump MySQL database Type the following command in command-line console. Load MySQL database Type the following command in command-line console.
SQL Command Set user password
SQL Command Revoke all privilege and grant option from user
SQL Command Grant all privilege to user on all databases(in MySQL system) with grant privilege. Grant all privilege to user on all databases(in MySQL system) WITHOUT grant privilege. Grant all privilege to user on a certain database WITHOUT grant privilege.
MySQL command Create user Notice. The ‘localhost’ means the accessible scope of the user is limited to the localhost. If your user account needs to be accessible from any IP address, change ‘localhost’ to ‘%’. Delete a user