0

how to change the default variable value in mysql

In my Mysql server ther exists many default variables which is shown in show variables command.

But i need to change to my need. Where i need to change or update.

ethan
asked May 12, 2017
1 Answer
0

You can change by providing value for the variables in my.cnf file.

For example:

If you need to change query_cache_size value go to my.cnf file and add the line in that.

Once its done, restart the mysql service and check it will be updated.

View More
jagannatharumugam
answered May 12, 2017
Your Answer
||||
​x
 
​
100:0

Related Tutorials in how to change the default variable value in mysql

Related Tutorials in how to change the default variable value in mysql

How to Install Pligg - Content Management System
How to Install Pligg - Content Management System
Jul 26, 2016
How to remove MySQL package completely on Ubuntu 16.04
How to remove MySQL package completely on Ubuntu 16.04
Apr 17, 2017
How To Install Mysql-Workbench On Linux Mint 20.2
How To Install Mysql-Workbench On Linux Mint 20.2
Apr 27, 2022
How to configure MySQL Master-Master replication in CentOS 7
How to configure MySQL Master-Master replication in CentOS 7
Apr 17, 2017
How to install MySQL from source on CentOS 6
How to install MySQL from source on CentOS 6
Nov 23, 2017
How to install Webmin in OpenSUSE
How to install Webmin in OpenSUSE
Nov 7, 2016
How to install and configure Asterisk in CentOS
How to install and configure Asterisk in CentOS
Jul 19, 2016
How to use Automysqlbackup and Autopostgresqlbackup
How to use Automysqlbackup and Autopostgresqlbackup
Apr 30, 2016

Related Forums in how to change the default variable value in mysql

Related Forums in how to change the default variable value in mysql

MySQL
rolando class=
Mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146)
May 9, 2019
MySQL
isaiah class=
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
Feb 8, 2017
MySQL
liam class=
How to check mysql history in Linux
Aug 28, 2017
CentOS Web Panel
anettejoseph class=
Centos Web Panel : How to find mysql root password
Jan 30, 2018
Database
john class=
Warning: mysqli::__construct(): (HY000/2002): No route to host
May 23, 2017
MySQL
julian class=
ERROR 1881 (HY000) at line 43: Operation not allowed when innodb_forced_recovery > 0
Apr 22, 2017
MySQL
muhammad ahmad class=
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
May 9, 2019
MySQL
gabriel class=
ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50560, now running 50642
Dec 14, 2018

Related News in how to change the default variable value in mysql

Related News in how to change the default variable value in mysql