Tag Info

New answers tagged

2

Much of the time, and probably in this case, just plain less will do the right thing. This uses the so-called less preprocessor. So, do less file.sql.gz This won't actually write the file in plain text to the filesytem; it is for your viewing pleasure only, but much of the time that is enough. I personally find the less preprocesor quite useful. It saves ...


1

gunzip -c <filename> | less or zcat <filename> | less


2

zcat file.sql.gz will output the file to stdout, which then can be combined with grep or more or less etc.


1

Setting class path The JDBC connector will be located in the path /usr/share/java/. We can export the classpath as, export CLASSPATH=/usr/share/java/mysql-connector-java.jar:$CLASSPATH Grant privileges to user For the user connecting to the database, the privileges should be granted. This can be achieved using the below mysql query. GRANT ALL ...


1

Your line in cron entry includes root and that's not needed, because when you invoke crontab -e it will start to edit cron as current user e.g root. All cron entries are located under /var/spool/cron/<user> so there you can check entries. Also in /var/log/cron you can check cron log with specific messages for cron jobs. So there you can check if action ...


0

Your crontab entry is: 00 11 * * fri root usr/bin/mysqlauditgrep mysqlauditgrep --format=GRID /var/lib/mysql/audit.log The table format is: # m h dom mon dow user command So your command seems to be: usr/bin/mysqlauditgrep mysqlauditgrep --format=GRID /var/lib/mysql/audit.log Which is not valid, there is no leading / and the mysqlauditgrep is ...


3

Your crontab line should be like this: 00 11 * * fri /usr/bin/mysqlauditgrep --format=GRID /var/lib/mysql/audit.log Type man 5 crontab to check the syntax of crontab file


2

Before posting the answer, I would like to iterate that I asked my question here and here. As one might suggest, this question belongs in dba SE. But the reason I post it here is because it involves editing the configuration file in /etc/my.cnf. First Solution Edit the /etc/my.cnf to include the below parameters. The configuration file location might vary ...


0

Just came across this question. I ran into this problem on Fedora 20 and discovered, duhhhh, that I had installed the 32-bit version of mysql-workbench on 64-bit Fedora 20 instead of the 64-bit version. After uninstalling the 32-bit version: $ sudo yum remove mysql-workbench and installing the 64-bit version instead $ sudo yum localinstall ...


2

Try: iptables -t nat -A PREROUTING -p tcp -d <public IP> --dport 53306 -j DNAT --to-destination 127.0.0.1:3306 What this rule does is: -t nat indicate the nat table -A PREROUTING meaning append this rule to bottom of PREROUTING chain -p tcp specific this rule only apply for tcp protocol -d <public IP> --dport 53306 meaning match all traffic ...


0

You need to install mysql-server and mysql-shared Packages



Top 50 recent answers are included