When trying to import large SQL dump, you often get the above message. Remedy for this issue is to increase the packet size of MySQL's daemon by setting a packet size of max_allowed_packet. Sudo to your account and set the following root $ mysql -u admin -p mysql> set global net_buffer_length=1000000; mysql> set global max_allowed_packet=1000000000; In the command line, issue the command $ mysql --max_allowed_packet=128M -uUSER -pPASSWORD database < database.sql.dump

After VPS reboot, you may encounter this issue and the fix is simple. Follow these stops to prevent this error. $ service mysqld stop $ mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak $ service mysqld start

To find the collation of tables within MySQL database, you can use one of the commands listed below mysql> show table status from exampledb; mysql> SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA='exampledb';   To find the character set used in a MySQL table mysql> SELECT tbl.table_name, CCSA.character_set_name FROM information_schema.`TABLES` tbl, information_schema.COLLATION_CHARACTER_SET_APPLICABILITY CCSA WHERE CCSA.collation_name = tbl.table_collation AND tbl.table_schema = "schemaname";

To find the collation of a database mysql> SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'exampledb' LIMIT 1; +------------------------+ | DEFAULT_COLLATION_NAME | +------------------------+ | utf8_general_ci | +------------------------+   To find the characterset of a MySQL database mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "exampledb";

Apache server is installed by default on Mac. Access the configuration settings for Apache by going to $ cd /etc/apache2/ $ vi httpd.conf To enable php, edit httpd.conf and uncomment the line #LoadModule php5_module libexec/apache2/libphp5.so Uncomment other lines that you may want to load in your system. As you are enabling PHP in your system, you may want to change the DirectoryIndex to DirectoryIndex index.php index.html Default group/user settings inside Apache on Mac is _www:_www (more…)

The reason why this message is shown is because the user for the view does not exist in the database. There are few ways by which we can remove this error i) Alter statement ii) Create the specified user in the database iii) Modify the .frm files related to the view and set the definer We will show the Alter statement method to achieve the desired results # To fix it: mysql> ALTER DEFINER = 'root'@'localhost' VIEW `mytableview` AS select * from cities; mysql> SELECT * FROM mytableview; Sometimes it so happens that the view statement will be a big selection of fields with joins in it. Export the table first to get the required SELECT statement for the view and then change the DEFINER