An open-source, relational database management system.
0
votes
1answer
18 views
Freeradius: MySQL query to show account expired yesterday
I have freeradius with mysql.using CLI, I want to list user account which have expired yesterday.
Currently I am using following command but it shows today account,
mysql -uroot -pSQLPASS -e "use ...
2
votes
2answers
38 views
High IO wait - How to determine the root cause?
I have a MySQL instance on two dedicated servers. One for the production, the other for the test platform.
The 2 servers are pretty the same, the only difference is the RAID controller and the ...
0
votes
2answers
55 views
Bash to match two variables for time difference
I have a bash command which gives me following result (Fetch user account details from the mysql using command
select creationdate from users;
Name Account Creation Date Mobile
User1 ...
0
votes
1answer
16 views
Install app on tiny core
How do you install mysql on tiny core? Also how do you install clamav? Can you install apt-get or yum on tiny core?
All should be done in command line / terminal
0
votes
1answer
25 views
MySQL process showing in top but no errors logged
I am seeing the following in TOP
2311 mysql 20 0 1324M 646M 9188 S 0.0 17.1 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin ...
1
vote
1answer
48 views
Permission denied writing to mysql log
I am just testing out a new Ubuntu (Vivid 15.04) install on Vagrant, and getting problems with mysql and logging to a custom location.
In /var/log/syslog I get
/usr/bin/mysqld_safe: cannot create ...
1
vote
0answers
67 views
libmysqlclient.so.18: cannot open shared object file: no such file or directory [closed]
I am using Slackware 14.1 x64 and when I want to run a program that is using mysql.h over C
I read the following error:
bash-4.2$ /home/normal/Proyectos/a.out
/home/normal/Proyectos/a.out: error ...
0
votes
2answers
27 views
How can I find where a program is installed or run from?
I installed centos and now I want to get into mysql via the command line, but I forgot my root password for mysql as its not the same as the root password I made to login to the system. I googled and ...
1
vote
0answers
34 views
mysql service exiting without error
I have installed mysql-community-server on openSUSE and am having trouble starting it as a service.
I can start it using sudo mysqld --user=mysql without a problem and access the database normally.
...
0
votes
1answer
31 views
Update mysql database specific field with this bash script
I am using the following bash script to update an email address "[email protected]" but the problem I have is that the field could be anything, not necessary "[email protected]" I have tried ...
1
vote
1answer
19 views
Update mysql database
How would I go about updating MySQL database X, table Y and column Z with "abc". How would I be able to do this without having to do so interactively from the mysql> prompt? I want to do this with one ...
-2
votes
1answer
29 views
Replace mysql field with X
I would like to update a MySQL database table column with x. How would I be able to do this without having to do so interactively from the mysql> prompt? I want to do this with one simple command.
1
vote
0answers
16 views
Zombie mysql process ? - linux Mint
I am having the following problem with MySQL and Mint:
mysql is set to run at startup: sudo update–rc.d mysql defaults
After startup the service is running and I can connect to the database through ...
1
vote
3answers
59 views
I can not install MySQL using yum on Centos7
I've installed centos7 recently, but, when I am trying to install MySQL using the command:
yum install mysql-community-server
I keep getting Exiting on user cancel while I am not hitting any ...
1
vote
1answer
33 views
Xampp installer Error
I tried to install xampp ver 5.5.24 on Debian using terminal, after setting it to run as executables in permissions with.
./xampp-linux-5.5.24-0-installer.run
I get
Segmentation fault
Then I ...
1
vote
2answers
40 views
Centos 7 - Recover mysql db from data files .frm and .ibd
I have migrated my operating system from Windows to Centos 7 without getting backup of mysql through mysqldump. Now I have mysql data files .frm and .ibd . I want to migrate them
How can I migrate ...
1
vote
2answers
30 views
How to pass password to mysql command line
I have MySQL password saved on a file foo.php, for example P455w0rd, when I try to use it:
$ cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2 | mysql -U root -p mydb -h friendserver
Enter password: ...
0
votes
1answer
32 views
php server can't connect to the remote mysql server
We have two servers.
server 1 and server 2
they are running with Directadmin / CentOS6
my plan:
server 1 is running php and html, images...etc.
server 2 is running mysql and phpmyadmin
They are ...
0
votes
2answers
53 views
Write permissions inside of shell script
I am using a Debian 7 Server. I created a shell script to be executed by crontab to save a mysqldump every day.
mysqldump *database* -u *mysql-user* -p*mysql-password* > ...
1
vote
0answers
16 views
Howdo i avoid older mysqlclient versions
i'm running some CentOS servers. PHP and MySQL are installed from 3rd party repos. My problem is that on all servers i always have php mysql clients running their version far behind the actual mysql ...
1
vote
1answer
84 views
List available SQL commands at MySQL CLI
Is there a way to list available SQL commands at MySQL CLI? I mean if I type help at MySQL CLI I see various MySQL CLI specific commands like clear(\c) or tee(\T), but it would be handy to see a list ...
0
votes
1answer
33 views
MySQL: connection refused…coudn't find mysqld.service
I am trying to install MySQL onto a Fedora 14 VM. I successfully installed it using
yum install mysql mysql-server
after which I tried to start it with
systemctl start mysqld.service
which ...
2
votes
0answers
106 views
MySQL read only error but permissions set and SELinux AFAICT correct
I am new to MySQL and Linux and because I had issues with an old MySQL version (5.1) I used mysqldump and installed MySQL 5.6. I changed the datadir location by copying everything to the new folder ...
2
votes
0answers
54 views
is THP good or bad for MySQL Server?
Linux kernel new feature called Transparent Huge Pages (THP) which is by default enabled on CentOS 6.x and above OS. Is THP good for MySQL DB machine?
I am trying following to disabled THP but seems ...
0
votes
0answers
62 views
HAProxy with Roundrobin working only on 2 of 3 MySQL servers, why?
Good day.
I'm following this article to configure HAProxy to balance with roundrobin between 3 MySQL servers (db1, db2, db3) in a MariaDB Galera cluster (working perfectly).
However I have a ...
0
votes
1answer
31 views
Appending to a CSV file after obtaining datum from a database
I can [finally] extract data from the MySQL DB
my_database_query="SELECT * FROM my_database.database"
mysql -uUSER -p'PASSWORD' << EndOfFile
$my_database_query
EndOfFile
How can I append this ...
1
vote
1answer
46 views
Unable to access another server over local network on Digital Ocean
I have two servers. Let's call them A and B. Both are running ubuntu server 14.04. B runs percona server. Now I do not have any firewall set-up on either servers still I am unable to connect to server ...
0
votes
0answers
368 views
Error starting MySQL in a MariaDB Galera cluster in CentOS 7
I'm trying to setup a MariaDB Galera cluster following this tutorial exactly as it is, and I'm stuck in the Step 7– Initialize the first cluster node, I'm doing so with sudo /etc/init.d/mysql start ...
0
votes
1answer
49 views
Rebooting Centos Servers configured with MYSQL Master/Slave Replication
Sometime ago we configured MYSQL replication on our main web server to another CentOS 6 server. All is working perfectly and we can see the replication is working fine.
My question is how to safely ...
2
votes
1answer
62 views
Why does logrotate zip a file before it is closed
I'm using logrotate to rotate mysql output. When cron runs logrotate, I get frequently get an e-mail with the following content:
error: Compressing program wrote following message to stderr when ...
0
votes
1answer
39 views
Looking for an email server that supports mysql ssl connection
I am trying to secure connections to my MySQL server. I have SSL set up but I am looking for programs that support a SSL connection to MySQL. Specifically I am currently looking for an email server ...
0
votes
2answers
136 views
import .sql file into a remote server from a local machine
I've created a database in the remote machine. Currently, the database is empty and I need to import using a backup(.sql) file. The backup file is in my local machine, it is a 40gb file. And the ...
0
votes
1answer
73 views
Mysql exited with status 1 and restarted every 24 hours? How to debug?
After upgrade, MySQL on Ubuntu 14.04 keeps crashing and is restarted every 24 hours according to the dmesg. I would expect to some reason for the failure in MySQL logs, but all are empty. Any ideas ...
1
vote
1answer
63 views
How do I troubleshoot these SELinux AVC errors?
Background: I have a CentOS 6 LAMP server. Recently the server has started to become unresponsive every few days. Originally, mysqld would throw a nagios alert and I would be unable to even ssh into ...
0
votes
1answer
81 views
How to move mysql database and mysql server to another machine
I am having Ubuntu 14.04 desktop in which i develop software. Due to some reasons my hard disk has developed many bad sectors. I want to move my mysql server software and all the databases to a new ...
2
votes
1answer
40 views
Option --skip-slave-start Not Working with Systemctl
I just started with centos 7. I'm trying to get replication working and am attempting to start mysql without starting the slave (so that I can set the pointers as to where it's supposed to resume ...
0
votes
1answer
106 views
Chromebook crouton LAMP
I'm trying to install a LAMP stack on Ubuntu through crouton on a Chromebook (Acer c720p).
I was able to install the following packages
apache2 mysql-client mysql-server php5 libapache2-mod-php5
...
2
votes
1answer
166 views
When saving INTO OUTFILE from mysql on a systemd based system, the output file is grabbed by systemd — why?
I regularly run simple reports from a mysql (actually, mariaDB) database:
MariaDB [acts]> SELECT resolution, title FROM acts ORDER BY resolution INTO OUTFILE '/tmp/acts-titles.txt';
Recently I ...
0
votes
0answers
237 views
Installing owncloud8 on CentOS 6
I'm trying to install owncloud 8 on CentOS 6 - the problem is that the default CentOS repos have only php 5.3 - but owncloud 8 requires php 5.4.
So following this guy:
How to install Owncloud on ...
0
votes
0answers
21 views
MYSQL dump of tables that start with docs_ from one server to another
The headline says it :) I would need script that dumps all tables from 'ads' database on different server(s2) starting with 'docs_' copied to my server(s1). Any hints? The reason that I need script is ...
1
vote
1answer
41 views
Not able to rename root user of MySQL
As part of security hardening, I wanted to remove/rename root user of mysql. While trying I get an error mysql.procs_priv doesn't exist.
what is the significance of 'mysql.procs_priv'? Is it ...
1
vote
1answer
186 views
Debian - problems updating mysql 5.6
I just tried to update my dev database that runs on debian 7.8. Unfortunately it's now giving me the folllowing error:
...
W: Failed to fetch http://repo.mysql.com/apt/debian/dists/wheezy/Release ...
0
votes
0answers
101 views
can't connect to remote host with MySQL…firewall problem?
I've granted privileges to thufir for remote access through the shell (correct?), but cannot seem to actually connect. The router firewall has SPI to off. I've disable the IPv6 firewall on the ...
0
votes
1answer
693 views
warning： mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623
warning： mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623
How do I do with it? I think I have a different version between mysql client and ...
0
votes
0answers
23 views
Postfixadmin keeps loading while adding mailbox
I have configured postfixadmin 2.92. While adding mailbox postfixadmin keeps on loading and does not return any information like mailbox is created. But in mysql the mailbox has been added. Later when ...
1
vote
1answer
43 views
FreeBSD Reinstall postfix with mysql support
I have installed postfix using the ports tree without making modifications to anything.
In my main.cf file i can't specify any 'Mysql:/' arguments because postfix does not have mysql support. Now i ...
1
vote
1answer
181 views
How to Subscribe a Bash Script as a MQTT Client
From my understanding:
Client can be any device as long as it has an MQTT library running on it, from a microcontroller to a server, but must be connected to an MQTT broker over any network
Broker ...
0
votes
1answer
42 views
Having problem with mysql dbdump when password starts with special character
I am trying to take a db backup with a php file that is running from a cronjob. It was running fine when I tested with sample db. But when I used the actual db there was an error.
I am using ...
0
votes
1answer
77 views
Combine the output of while loop into tar
I'm trying to create a script that mysqldumps all my databases, creating an individual .sql file for each database and combines the output into backup-DATE.tar.gz.
I've gotten as far as being able to ...
1
vote
1answer
76 views
Calculating RAM/Swap Space Requirements [duplicate]
I have been developing a MySQL database that makes some use of BLObs. This has now been transferred on to a virtual machine (VM) in preparation for going fully into the 'cloud'. However some of the ...
