I am trying to automate mysql_secure_installation script with automated response. My code is as follows : The actual questions which i am automating are as follows: But it gives me an error “Sorry you cannot use an empty password here” but in the screen i used to press the return key for the first…
Tag: mysql
How to download Mysql jdbc jar file on centos
Sorry for my noobness. I’m very newbie in linux and using CentOS. I need to download Mysql jdbc and place it in somewhere. So I searched on Google and couldn’t get any proper result. All results say that download it from http://dev.mysql.com/downloads/connector/j/5.1.html site or download rpm and …
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
I just manually installed a new plugin on my WordPress site, created a table in MySQL for the plugin’s entries, and when I try to open the page that uses the plugin, I receive this error: This is the MySQL info listed in my config file (which I believe is correct): This is the main contents of the /etc/…
python 3.x no module named sqlalchemy after installation
I’m trying to install sqlalchemy to interact with mysql database for my python 3.x with ubuntu 12.04, but then when I import the sqlalchemy it says no module named sqlalchemy. This is what i did with installation: Did I do something wrong? Answer By using apt-get you have installed sqlalchemy in the def…
Best way to install MySQL 5.6 on Centos 6.4
I just installed Centos 6.4, and installed MySQL using the version that came with the Centos distribution. To my dismay, it is MySQL 5.1.69 versus the current 5.6.12. As stated on http://dev.mysql.com/doc/refman/5.5/en/linux-installation-native.html, “the MySQL version will often be some way behind the …
Insert into mysql from linux terminal
I have a question. i can insert into mysql database from linux terminal a record with this command: Now i have a file in Linux with some records for example: i don’t know how can i insert all records to the file to mysql database from linux terminal. I intent with a bash file but i don’t know =( A…
Get the MySQL path
I tried googling to get the MySql path, but it was unsuccessful. Is there a unix command, where I can find the MySQL database directory path? Answer Try this query, SHOW VARIABLES LIKE ‘datadir’;
database and wordpress backup cron job
i want to run a cron job that back ups my mysql database and my wordpress files once a day from the hostgator cpanel. i found a sample script and edited the parameters with my information but it doesn’t seem to be working properly. I don’t have much experience with cron jobs so i’m not sure …
Linux Mandriva: Tomcat can not get MySQL database connection, why?
I installed Tomcat 7 and MySQL database on Linux Mandriva, but the application is deployed in the container can not get a connection. I wrote two simple tests, and when to run them from the client, I get the connection – Part of HibernateUtil – Jdbc test – In these cases, I get a connection …
Linux Mint trigger slowly query on mysql on system booting
My debian-based is booting so slow after I installed MySQL and imported some databases on it. Looking for some statement, I found this one during boot: Here the statement that causing trouble: I have +-10 databases totaling over 8gb of data. Is there any configuration to disable this query on system booting ?…