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  

When we began creating an application using Struts2 framework with Hibernate and MySQL, we ran into a problem which was related to MySQL timing out its connection after a span of 8 hours when left unused. It conceived a lot of time at our end but we were able to nail down the issue at the end. Steps that we had taken to correct the issue related to Hibernate MySql connection timeout problem are listed below - Download Hibernate C3P0 and copy .jar files - Set c3p0.properties - Make changes to hibernate.cfg.xml - Test MySQL connection timeout - Hibernate, MySQL connection timeout related error messages (more…)

List the listening ports and check if mysql is listed on it. $ netstat -tln | grep mysql If you cannot find the port number for mysql view my.cnf file to see if you can find the port number. If you see a line "skip-networking" try commenting out the line and then restart mysql daemon. $ vi /etc/my.cnf [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-networking [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid $ service mysqld restart