An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
0answers
31 views

completely clean re-install of mysql on CentOS 7

I have encountered problems with a mysql installation on CentOS 7. All the data is backed up, so I just want to completely erase every remnant of mysql on the machine and then do a clean install. My ...
1
vote
2answers
586 views

Allow remote MySQL to a specific IP - using CentOS 6.4

I've spent a day now trying to find out how to allow remote MySQL to work for my other virtual server. This is proving very difficult so I'm hoping you guys could help me out ;( I've used the ...
0
votes
2answers
379 views

How to install MySQL Workbench on Fedora 21

Is there an easy way to install MySQL Workbench on Fedora 21? I could not find a RPM package and failed at compiling it from source because I am using MariaDB and therefore was unable to install ...
0
votes
1answer
13 views

Apache / php config for production & staging & development

I have a server that has a production server a staging sever and a development server. I maintain code by changing it on the development server testing it. Then staging it and testing it and then ...
3
votes
2answers
2k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be found on the following packages: ...
1
vote
0answers
22 views

I Need Find A Mac Address from a client connected to my Teamspeak

I have a dedicated server and from it I am running a teamspeak 3 server. In teamspeak server there is a client who need to be banned. I have banned him from teamspeak but if you change your windows ...
0
votes
1answer
25 views

compiling php 5.4 and higher with mysql

i'm running a pile of mediawiki instances on oracle enterprise linux and i'm trying to upgrade from 1.19.x to the latest LTS version, 1.23.x. i'm currently using php 5.3 and due to some odd issues ...
0
votes
3answers
38 views

MySQL Database Missing on UNIX server. Possible to recover? [closed]

My dedicated server is VERY old (running Apache/1.3.37 (Unix) PHP/4.4.4 FrontPage/5.0.2.2510). We have a script that runs and manages our customer database. Early in the morning last Friday, it was ...
1
vote
1answer
773 views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
0
votes
1answer
20 views

How to slow down MySQL service autostart on boot (dependency on another service)

I'm running a MySQL database on Debian on RaspberryPi (Raspbian). I would like to use the RaspberryPi as a local MySQL server, but to have the MySQL database datadir outside RaspberryPi's SD card - ...
-1
votes
1answer
75 views

php: command not found on centos

I've currently installed CentOS (6.5 version), nginx, mysql and php. I've tried to navigate to index.php in a browser, and it looks fine, but if I try to run the script via the command-line I get: ...
0
votes
1answer
365 views

Creating MySQL database and user without password

I am building a set of bash scripts which basically prepare apache virtual hosts, git repositories and other stuff on a cloud server. So far so good, everything is working, but a big problem occurred: ...
1
vote
2answers
153 views

Shell: How to uninstall all related packages to a specific one? / Ubuntu

Recently I asked to my hosting provider to reload the OS to Ubuntu 12.04 64 bit minimal assuming minimal would have the minimum required packages installed, but I realized that mysql was installed so, ...
2
votes
1answer
488 views

Can't use my old my.cnf from MySQL 5.5.38 in newer 5.6.19

Ok so I have been trying to upgrade MySQL 5.5 to 5.6. I have been given this set my.cnf file (see below). I was able to uninstall the MySQL 5.5 rpms and install the 5.6. When I reload the back up ...
4
votes
1answer
349 views

I get the Error “mysqld dead but pid file exists”

I get the Error mysqld dead but pid file exists This happens every couple of hours. If I restart it works fine and then goes down again. [root@ip-10-0-0-149 log]# df -h Filesystem Size Used Avail ...
0
votes
0answers
45 views

writing mysql output to file in CentOS 7

I am trying to run the following command from inside the mysql command line client in the CentOS terminal: SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') FROM ...
1
vote
1answer
1k views

Start Mysql/Mariadb in Fedora failed

failed to start mysql in Fedora 17. I am using root account to run the below commands and selinux is disabled. service mysqld start Redirecting to /bin/systemctl start mysqld.service Job for ...
0
votes
0answers
16 views

Sharing MySQL data between Windows and Linux?

I'm trying to share my MySQL database files between a Windows and a Linux distro (Mint). I have a dual boot plus a separate data partition (NTFS). I've tried mounting the partition with ownership on ...
0
votes
2answers
46 views

Substituting \ for \\ in column

I exported a column of thousands of salts from Mysql for hashcat. Every instance of the character \ was replaced with a double character \\ in the exported column. Is there a way to either sed or awk ...
0
votes
1answer
27 views

If I install MySQL-python using pip, does that means that I can use MySQL server/client?

I have installed MySQL-python using pip. Does that mean Mysql has also been installed in my system? If than, how can i access it through terminal command?
2
votes
2answers
459 views

Import single rows from SQLite to MySQL?

I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
2
votes
3answers
130 views

setting mysql root password in CentOS 7

How can I log into the mysql 5.6 command line client and reset the root password in Centos7? I read the following at this link, but it does not work: 1) sudo service mysqld stop 2) sudo service ...
0
votes
2answers
47 views

How do run MYSQL scripts from a shell script with bash variables?

Im making a script where I connect to a database, look for a value and then if that value returned something then I will do something else. ip=$("variable is defined here") Then I connect to the ...
0
votes
2answers
20 views

What does this host means ' ::1 '

To secure my mysql server, I checked the list of users : mysql> SELECT User,Host,Password FROM mysql.user; +------------------+-----------+-------------------------------------------+ | User ...
1
vote
2answers
987 views

Installing mysql-server in vagrant bootstrap shell script (how to skip setup?)

I did try to install mysql-server on my Vagrant Ubuntu 12.04 LTS virtual machine. When I did so, the setup auto-starts. I can see this in the Vagrant output: While not mandatory, it is highly ...
0
votes
1answer
57 views

MySQL (MariaDB) too many connections that don't close?

I have recently acquired my first VPS to run a mysql server for my minecraft server, I have setup MariaDB, it's using the default settings at present. I tested it last night with one plugin ...
0
votes
1answer
2k views

What caused my CentOS 6.4 box to reboot itself?

I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant: 121229 22:17:45 mysqld_safe mysqld from ...
0
votes
0answers
48 views

How to properly install Apache, MySQL, and PHP on Ubuntu 10.4

I have followed a guide on how to install Apache, MySQL, and PHP on my laptop running Linux (Ubuntu 10.4) It appears I have it installed correctly but when I am not sure. I followed this guide here: ...
0
votes
1answer
19 views

Does mysql user exist in MySQL database system

I searched mysql.user table and did not find any user named as mysql. root is the default username. I am curious to know whether mysql user exist or not? If yes, what is the purpose of this user? ...
1
vote
1answer
250 views

How to configure the MySQL APT repo on Ubuntu, on a non-interactive shell?

I want to install MySQL 5.7 on Travis CI, which runs Ubuntu 12 virtual machines. I'm willing to use the official MySQL APT repo: wget ...
1
vote
1answer
52 views

How do I properly bind directories inside chroot jails using fstab?

I'm running nginx, PHP-FPM and MySQL on Debian Wheezy. I've set up chroot jails (with debootstrap) for each individual virtual host in /srv/. Everything is working like one would expect, but after ...
1
vote
1answer
17 views

Linux firewall techniques: MySql-Account

I'm having a discussion with a software developer in my nears. He is using MySql direct connections for a software. There is no PHP/SSH/whatever-Bridge involved for the communication, neither at ...
0
votes
1answer
56 views

export from MYSQL to CSV

How do I export from MYSQL to CSV in mariadb on Centos 7? I am using: Server version 5.5.37-MariaDB Protocol version 10 Connection Localhost via UNIX socket UNIX socket ...
1
vote
2answers
28 views

Running SQL call as root user in init.d script?

I have a SQL query that must be run on every startup after a software update (updates come with new installations of mysql and thus change the debian-sys-maint user's password, which my script updates ...
4
votes
0answers
43 views

MySQL has over 95,000 connections but processlist is empty?

I have a server that is running mysql and it's using a lot of memory. I run: mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | ...
5
votes
3answers
5k views

How can I upgrade MySQL in Debian using apt-get?

I'm using the Turnkey Linux virtual machine. The version of Debian in there is apparently on the "Wheezy" upgrade path (if that's what you call it). I'm not completely comfortable with Linux, as you ...
0
votes
3answers
252 views

Run an SQL script to create a Database via Linux Terminal

I am logging into my web server remotely using SSH and I'm wondering if there is a way that I can execute an sql script I have residing in a directory on that server in order to create a new database, ...
0
votes
2answers
81 views

Bash Mysql Command Substitution Login Failure

Bash and MySQL versions: GNU bash, version 4.2.25(1)-release (x86_64-pc-linux-gnu) mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2 I have a bash script that tries ...
0
votes
3answers
55 views

mysqld is not starting up anymore due filled disk [duplicate]

How to clean logs or find largest files and reduce the space? also i do not understand 1.7T is not even used in this critical moment. Mysqld is not running because 99% is used. # df -h Filesystem ...
2
votes
1answer
93 views

Creating an SSH tunnel from a linux VPS to a web server database

I'm creating a server application that clients will connect to. The server application is running on an Ubuntu Server 14.04.1 VPS. The server needs to be able to connect to a MySQL database hosted on ...
1
vote
1answer
74 views

Cacti/rrdtool error -> Poller[0] ERROR: SQL Row Failed!, Error:'1033'

I have cacti working flawlessly on a centos 7.0 machine but I need it working on a centos 6.3 machine. I download the same version of cacti as what is on the 7.0 and I installed rrdtool from yum. ...
3
votes
1answer
109 views

Can't start the MySQL service on a recently upgraded VM

I have a VM running Ubuntu server which I just upgraded to 14.04. The VM provides access to a MySQL database. However, after upgrading, the database refuses to start and I don't know enough about it ...
0
votes
1answer
78 views

Mysql database didn't connect through sqlyog or any other mysql software?

I can connect to a MySQL server through a browser and also I can show all database list through PuTTY. But when I try to use sqlyog or running the mysqldump command through PuTTY it shows this error: ...
1
vote
4answers
521 views

Multiple Mysql databases backup tool?

My OS is Ubuntu 10.10. I have several small sites (all on various shared hosts) and I'm thinking that it'd be probably good idea to regularly backup mysql databases from these remote shared hosts. I ...
0
votes
1answer
434 views

MySQL max_open_files more than 1024

While starting MariaDB I got [Warning] Could not increase number of max_open_files to more than 1024 (request: 4607) $ sudo systemctl status mysqld ● mysqld.service - MariaDB database server ...
2
votes
1answer
69 views

Why does mysql server packages have perl dependencies in linux distros?

I'm trying to clean out some unneeded packages from one of my gentoo boxes with emerge --depclean, and I thought I had a few perl modules installed that none of my wanted packages should require. So, ...
0
votes
1answer
161 views

MySQL startup errors: ERROR 1005

My Debian MySQL installation gives this: Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 ...
1
vote
1answer
77 views

Establish connection between Qemu Raspbian machine and Host

Objective: I would like to install several virtual (emulated) Raspberry machines on the laptop, connect them to each other and to the laptop. Afterwards I would like to send tcp packets from virtual ...
0
votes
1answer
42 views

Mysql Database files read access

Right now I'm trying to set read access to the files of one of my databases. I'm using debian with basic mysql installation so the database location is /var/lib/mysql. I want ...
3
votes
5answers
1k views

Encrypt a password the same way mysql does

I've created a user ... but forgotten the password mysql> create user 'blayo'@'%' identified by 'right'; Which Linux command line tool can encrypt the password the same way mysql 5.5 does ? ...