Category: MySQL

Interview Questions of MySQL

August 7, 2016 by Arti Khedkar

Filed under Database, MySQL

Last modified August 7, 2016

         Interview Questions of MySQL What is MySQL? In which language MySQL is written? What are the technical specification of MySQL? How many Triggers are possible in MySQL? What is heap table? What is BLOB and TEXT in MySQL? What is a trigger in MySQL? What is the difference between heap table and temporary table? What is the difference between FLOAT and DOUBLE? What are …

MySql Connection

July 17, 2016 by Arti Khedkar

Filed under Database, MySQL

Last modified July 17, 2016

MySql Connection Command   Every connections of mysql are based on storage space in a disk. So you have to set that maximum connection based on work load on disks have command. In mysql 100 connections are maximum connections. MySQL stands for My Structured Query Language. It is a open source database software. A NULL value is not equal to itself. If you compare a …

Setup Mysql Database for Bugzilla

February 5, 2016 by S4

Filed under Database, MySQL

Last modified July 15, 2016

Setup Mysql Database for Bugzilla You need MySQL version 5.0.15 or higher. It’s possible to test which version of MySQL you have installed with: mysql -V 1.1 Installing 1.1.1 Windows Download the MySQL 32-bit or 64-bit MSI installer from the MySQL website (~28 MB). MySQL has a standard Windows installer. It’s ok to select a Typical MySQL install (the default). The rest of this documentation …

max_connections at AWS RDS MySQL Instance Sizes

February 4, 2016 by Linux Guru

Filed under AWS, Database, MySQL

Last modified July 15, 2016

max_connections at AWS RDS MySQL Instance Sizes This chart shows the max_connections limit, set by AWS, at various MySQL RDS instance sizes. t2.micro 66 t2.small 150 m3.medium 296 t2.medium 312 M3.large 609 t2.large 648 M4.large 648 M3.xlarge 1237 R3.large 1258 M4.xlarge 1320 M2.xlarge 1412 M3.2xlarge 2492 R3.xlarge 2540 AWS sets the MySQL max_connections system variable according to the size of the RDS instance.  max_connections is the …

Reset MySQL Root Password in Windows

December 31, 2015 by Linux Guru

Filed under Database, MySQL, Window

Last modified July 15, 2016

Reset MySQL Root Password in Windows 1] Log in to your system as the “Administrator” user created in Windows setup. 2] Stop the MySQL service by clicking “Start,” “Control Panel,” “Administrative Tools,” “Services.” Scroll down to “MySQL.” Click “Stop.” 3] Open Notepad from the Start menu and enter the text: “UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root.’“ 4] Save the file to an easily accessed location …

Access denied for user ‘root’@’s4techno.com’ (using password: NO)-Linux OS

December 31, 2015 by Linux Guru

Filed under Database, MySQL

Last modified July 15, 2016

Access denied for user ‘root’ using password If you are getting this error message while accessing mysql from the shell then make sure that you have done $su – from the command prompt after that fire #mysql even if you are getting that error message then you need to reset the mysql password you can use following steps for it first locate your mysql’s hostname.pid …

mysqld dead but subsys locked

December 23, 2015 by Linux Guru

Filed under Database, logs, MySQL

Last modified November 30, 2016

mysqld dead but subsys locked MySQL error:-” mysqld dead but subsys locked “ [root@s4tehno ~]# service mysqld status mysqld dead but subsys locked. Then check processes list. [root@s4tehno ~]# ps -aux | grep mysql root      1877  0.0  0.0   5216  1844 ?        S    Mar15   2:55 /bin/sh /usr/bin/mysqld_safe –datadir=/var/lib/mysql –socket=/var/lib/mog-error=/var/log/mysqld.log –pid-file=/var/run/mysqld/mysqld.pid root      4177  0.0  0.0   4048   712 pts/1    S+   14:35   0:00 grep mysql Try to restart mysqld …

MySQL Error 1418

December 23, 2015 by Linux Guru

Filed under Database, logs, MySQL

Last modified June 15, 2016

MySQL Error 1418 ERROR 1418 (HY000) at line 5: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) Solution: # mysql -u root -p MySQL> SET GLOBAL log_bin_trust_function_creators = ON; OR MySQL> # SET GLOBAL log_bin_trust_function_creators = 1; Reason: ERROR 1418 (HY000): This function …

Secure a MySQL installation on Linux

December 23, 2015 by Linux Guru

Filed under Database, MySQL

Last modified June 15, 2016

Secure a MySQL installation on Linux It shouldn’t surprise you that MySQL includes a tool that helps to secure the installation. This is only available on Linux, but it should be one of the first steps to take when the install is complete. Here’s what you need to do. The tool is the mysql_secure_installation command and is run from the bash prompt. This script is …

Difference between MySQL CE and MySQL Enterprise edition

December 23, 2015 by Linux Guru

Filed under Database, MySQL

Last modified June 15, 2016

Difference between MySQL CE and MySQL Enterprise edition Difference between the community edition and the enterprise edition is added support and tools. The server itself is the same, but the enterprise edition gets updated more frequently and it is stable with quick bug fix support. It would be safe and will not make any problem if the decide to move on to ORACLE in future. …