Category: Database

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 …

Backup PostgreSQL Databases Server With pg_dump command

December 28, 2015 by Linux Guru

Filed under Database

Last modified July 15, 2016

Backup PostgreSQL Databases Server With pg_dump command PostgreSQL is a one of the robust, open source database server. Like MySQL database server, it provides utilities for creating a backup. Step # 1: Login as a pgsql user Type the following command: $ su – pgsql Get list of database(s) to backup: $ psql -l Step # 2: Make a backup using pg_dump Backup database using …

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. …

Convert MSSQL database to MySQL database

December 22, 2015 by Linux Guru

Filed under Database, MySQL

Last modified June 15, 2016

Convert MSSQL database to MySQL database Some time ago, I had to convert a Microsoft SQL Server database to a MySQL database. The main reason was the cost of the SQL Server license for such a small database. Looking on the web, I found the following open source application: Name: mssql2mysql URL: http://sourceforge.net/projects/mssql2mysql/ Description: mssql2mysql is a python script used to create a SQL dump …

MySQL-fix “table is marked as crashed and should be repaired”

December 17, 2015 by Linux Guru

Filed under MySQL

Last modified June 15, 2016

MySQL-fix “table is marked as crashed and should be repaired” How to fix “table is marked as crashed and should be repaired” ? Power outage or a buggy mysql version could cause this error to appear: Stops any php scripts from running etc.. mysql: Table ‘database/table’ is marked as crashed and should be repaired To fix this, I ran this command via a shell: $ …