2018-12-10 09:55
wget http://curl.haxx.se/download/curl-7.21.1.tar.gz tar zxvf curl-7.21.1.tar.gzcd curl-7.21.1/./configure --prefix=/usrmake && make installcd ../echo "/usr/local/webserver/mysql/lib… Read More
Blog Directory > Technology Blogs > Research Blogs > Mysql Tech Tips research Blog >
Mysql Tech Tips Blog
anchaltechtips.blogspot.in
Tags:
root pmypassword
mysql slow
rsolved error
root
mysql dba
outfile csv
sleeping connections
pre authentication protocol
grantpriv
string soname
Mysql related day to day solved issues
2018-02-23 07:26
Rsolved ERROR 1290 (HY000): INTO OUTFILE CSV FILEThe MySQL server is running with the --secure-file-priv option so it cannot execute this statementFind out where you are allowed to writemysq… Read More
2018-01-25 06:44
Padmavat 2018 Full Movie Download HD 720pPadmavat Movie Download HDClick Here to Download Padmaavat Moviehttp://moviestrunk1.xyz/padmaavat-movie-download-hd-720p-full/Padmavati formerly… Read More
2018-01-04 05:22
Unable to connect mysql server remotely ,The connection seems OKit might because of mysql client bug You need to update or downgrade the MySQL Client You must upgrade the "old… Read More
2017-10-26 12:52
A error occured when run `mysql` from the terminal to connect to a server.Add `--skip-secure-auth` to the end of the statementmysql -u repluser -p'myreplpass' -hxx.xx.xx.xx --skip_secu… Read More
2017-10-20 07:46
List of all mysqladmin flush commands.flush-hosts: Flush all information in the host cache.flush-privileges: Reload the grant tables (same as reload).flush-status: Clear status variables.flu… Read More
2017-05-11 09:51
Mysql dba tips and tricks: ERROR 1044 (42000): Access denied for user Restor...: Access denied for user 'root'@'%' I am able to login fine : mysql -u root -p mysql> GRAN… Read More
2017-05-11 09:48
Access denied for user 'root'@'%'I am able to login fine : mysql -u root -pmysql> GRANT SELECT, LOCK TABLES,EXECUTE ON `dbname`.* TO 'dbuser'@'xx.xx.xx.xx' IDENTIFIED BY… Read More
2017-04-10 06:57
How to understand the MySQL Slow Query Logroot@server#tail -f /var/log/mysql_slow_query.log# Time: 2017-04-09T20:10:09.472872Z# User@Host: db_user[db_name] @ [x.x.x.125] # Query_time:… Read More
2017-01-17 06:40
INFORMATION_SCHEMA, For instance, counting the number of sleeping connections can be done with:mysql> SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND='Sleep';+… Read More
2017-01-11 09:46
The Solution: Zmanda Recovery Manager for MySQLZmanda Recovery Manager for MySQL (ZRM for MySQL) simplifies this essential part ofdatabase administration with an easy-to-use yet powerful fra… Read More
2017-01-02 13:37
Tools to monitor MySQL performance and troubleshoot a serverMytopMytop is open source and free console-based (non-gui) monitoring tool for MySQL database Mytop runs in a terminal and display… Read More
2016-12-21 06:52
You can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file$ mysqldump --opt -u [uname] -p[pass] [dbname] > [back… Read More
2016-12-13 09:38
Administrative privileges enable users to manage operation of the MySQL server.Privileges for database objects such as tables, indexes, views, and stored routines can be granted for sp… Read More
2016-10-07 07:46
mysql> repair table my_table;+------------------------------+--------+----------+--------------------------------------------------------------------------+| Table &n&hell…Read More
2016-10-06 06:18
1.First cross check /etc/my.cnf to make it permanentslow_query_log = 1slow_query_log_file = /var/log/mysql_slow_query.log2.Permission ofmysql mysql 763482 Oct 6 11:43 /var/log/my… Read More
2016-08-16 10:14
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work1. check and correct server-id under /etc… Read More
2016-06-09 04:54
Mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control this behavior:Assume we want to backup only the store… Read More
2016-05-23 08:53
Add this in my.cnf and then restart MySQL server:general_log = 1log=/var/log/mysql_slowquery.logYou can check whether the general_log is 'ON' or 'OFF' first using query:mysql>show variabl… Read More
2016-05-19 05:34
The easiest way isALTER TABLE table_name ENGINE = InnoDB;InnoDB uses row level locks Read More
2016-05-19 05:15
use mysqlcheck with --optimize and --databases combination. mysqlcheck is a command-line interface for administrators mysqlcheck -uroot -p --optimize --databases myDatabaseOptimiz… Read More
2016-05-10 10:26
Depending on the size of the databases you have in mysql innodb the time it takes mysql to restart can be very slow.Some tricks that can speed this upmysql> set global innodb_max_dirty_pa… Read More
2016-05-03 07:13
You can also issue SELECT without a table. For example, you can SELECT an expression or evaluate a built-in function.mysql> select 1+1;+-----+| 1+1 |+-----+| 2… Read More
2016-05-03 06:56
Simple and smart reset mysql root password# /etc/init.d/mysql stop# mysqld_safe --skip-grant-tables &# mysql -u rootmysql> use mysql;mysql> update user set password=PASSWORD("newro… Read More
2016-05-03 06:51
Using SELECT INTO, we can save the output of a select command into a file.Instead of displaying the output on the screenmysql> SELECT * INTO OUTFILE '/tmp/employee.txt' FROM employee;We c… Read More
2016-04-28 05:06
You are running a multi-user MySQL database, some useful commands that show a list of all existing MySQL usersand their privileges. To find out all MySQL users and the permissions granted to… Read More
2016-04-21 07:28
mysql can do that for you. Use mysql -H or mysql-X.mysql generates an HTML table from each query result set if you use the -H (or --html) option mysql creates an XML document from the result… Read More
2016-04-21 06:05
After you installed MySQL-community-server 5.7 from fresh on linuxgrep 'temporary password' /var/log/mysqld.log Read More
2016-04-19 06:44
Find mysql upgrade checklist1.Dump all databases/schemas from the existing mysql server by using mysqldump command2.intall/Initialize a new MySQL 5.7 server instance3.Load the dump file into… Read More
2016-04-18 12:59
Mysql 5.7 password verification plugin (and impacts to PASSWORD() function)mysql> SHOW VARIABLES LIKE 'validate_password%';+--------------------------------------+--------+| Variabl… Read More
2016-04-18 11:33
In MySQL 5.7, the password field in mysql.user table field was removed, now the field name is 'authentication_string'.First use the databasemysql>use mysql;mysql>show tables;You will f… Read More
2016-04-14 06:47
Server timed out and closed the connection. To fix, check that “wait_timeout” mysql variable in your my.cnf configuration file is large enough Server dropped an incorrect or… Read More
2016-04-13 09:59
The below MySQL command will show server version and currently selected Database. mysql> SELECT VERSION(), DATABASE(); Read More
2016-04-05 10:09
Rather than typing the query repair table ''tablename''; for all the tables one by one.# mysqlcheck -u root --password=thepass --auto-repair --check --all-databases Read More
2016-03-29 13:36
To check all the tables in a particular database, don’t specify the table name. Just specify the database name. The following example checks all the tables in the db_name da… Read More
2016-03-10 11:36
MySQL has a nice feature: MySQL slow query log, which allows you to log all queries that exceed a predefined about of time to execute.Go or define mysql slow query file path and runmysqldump… Read More
2016-01-27 09:46
Query caching is one of the important features in MySQL and a vital part of query optimizationmysql>show VARIABLES where variable_name regexp 'query_cache';+… Read More
2016-01-25 07:30
mysql> REPAIR TABLE mytable QUICK;+—————-+————+—————+—————+| Table … Read More
2016-01-25 07:28
You can have MySQL return query results to you in well-formed XMLshell>mysql --xmlmysql> SELECT * FROM test.stories; 1 This… Read More
Subscribe to Mysql Tech Tips
Get updates delivered right to your inbox!