New answers tagged

0

Found the problem. The autoconf option of the plugin reported this error: [root@linuxbox ~]# /usr/share/munin/plugins/mysql_ autoconf no (DBI connect('mysql;mysql_connect_timeout=5','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO)) Then I realized /etc/munin/plugin-conf.d/munin-node was missing the mysql plugin ...


2

You are mixing CentOS 6 packages (.el6) with CentOS 7 packages (.el7), which is invalid. They differ a lot. You installed mysql56-community-release-el7.* instead of mysql56-community-release-el6*, where from you get that. Remove this wrong package source: yum remove "mysql56-community-release-el7.*" Install the correct one (as you installed the above ...


1

You can try: dbsetup="CREATE DATABASE ${newsitename}_db;GRANT ALL PRIVILEGES ON ${newsitename}_db.* TO 'site_usr'@'localhost';FLUSH PRIVILEGES;" Double quotes will corrupt your string.


0

If you allow extra tooling (after all you tagged mysql) you could do it with one command from the dateutils package: $ dateconv -i %m-%d-%Y "9-2-1832" 1832-09-02 The difference to GNU date is that you can specify the input format using format specifiers (the -i parameter). That way any kind of date can be parsed. As you wanted standard ISO 8601 ...


0

If you store only backups of MySQL on your / partition then it's easy to move the data. Assume you're storing your data in /opt/backup/ you can: Stop the backup from writing to that directory ( if you're using some backup program ) Move backup folder in / to /home/ ( or any folder in /home as you want) # mv /opt/backup/ /home/ Create a symbolic link to ...


0

You first need to get your root partition ("/") down from being full or many bad things will happen in your system. It needs /tmp to be writeable for many system and user tasks. Your root partition is only 50GB so you're never going to get the space you need there with current partition structure. Your options would be to repartition to get a separate /var ...


0

Assuming your original date is "month-day-year" (September 2, 1832), something like this might work: $ date -d $(sed "s/-/\//g" <<< '9-2-1832') +%Y-%m-%d 1832-09-02 Explanation The date command, even at the current 8.25 version, won't accept a date of the format you list ('9-2-1832', a month-day-year date string with hyphens as separators). $ ...


1

To install latest MySql 5.7 on RHEL/Centos 7. There are few steps follows-: Step 1-: Add the below EPEL Repository $ sudo rpm -iUvh http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm Step 2-: Install the MySql Server using below yum installer. $ sudo yum install mysql-server Step 3-: Add to system Startup and start the Mysql Server. ...


0

It looks like the best choice isn't to do it by hand, but through more SELinux automation. grep mysqld /var/log/audit/audit.log | grep shm | audit2allow -M mysql_tmpfs semodule -i mysql_tmpfs.pp The audit2allow(8) man page says the -M argument uses the next string as the new module name. Between that and the semodule(8) man page, I want to use a module ...


4

This mysql> is not a directory. It is the mysql database prompt, where you can execute mysql commands. You can exit this CLI by typing "quit".


1

The guys from MySQL replied and declared this as a bug. The following is their message: Hi, Thanks for the report. This seems to be a bug in the new version of mysql-apt-config. In your /etc/apt/sources.list.d/mysql.list file, the line: deb http://repo.mysql.com/apt//debian/ jessie mysql-5.6 mysql-5.7-dmr mysql-5.7 connector-python-2.0 ...


0

Personally, I found bish-bosh a tad over complicated for my tastes. I am not great with sql, but I'll take a stab at the mqtt part. You will need a listener running mosquitto_sub to read and exec commands, and on your terminal you need to subscribe to an output stream. Finally, you will need a handler to send commands with. For a listener, you can try ...



Top 50 recent answers are included