New answers tagged mysql
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 ...
gunzip -c <filename> | less or zcat <filename> | less
zcat file.sql.gz will output the file to stdout, which then can be combined with grep or more or less etc.
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
You need to install mysql-server and mysql-shared Packages
Top 50 recent answers are included