An open-source, relational database management system.
-1
votes
1answer
39 views
Why is mysql not starting? [on hold]
As per suggestion I have also made a ticket on dba stack exchange here:
http://dba.stackexchange.com/questions/134594/why-is-mysql-not-starting
When running the command 'sudo service mysql start' ...
-5
votes
0answers
33 views
I want to log in to mysql from linux [on hold]
I am trying to write a shell script to log in to mysql and load data automatically after creating.
0
votes
0answers
17 views
Automatic Set Up of MySQL
I sometimes have call to install some bespoke software onto Linux systems and am using 'distutils' for this. In addition to this I also install some Python packagers that are not in the default ...
0
votes
1answer
36 views
Can't connect to local MySQL server
I want to run a website from my computer. I use XAMPP on a Kali Linux.
I installed MySQL server with the command: apt-get install mysql-server
After it successfully installed, I entered the command ...
0
votes
1answer
30 views
Why is crontab executing on one server but not the other?
I have two servers on linode that have some websites on them. I created a script to see if mysql is running on the server and if it's not running then the script will start mysql. The script is on ...
0
votes
0answers
11 views
Error when building & installing setup.py for MySQLdb
I'm attempting to build then install MySQLdb but I run across the following error:
omars-mbp:MySQL-python-1.2.4b4 omurad$ sudo python setup.py build
Password:
Extracting in /tmp/tmpp9ns_p46
Traceback ...
1
vote
2answers
46 views
install mysql - has no installation candidate
I used to install mysql 5.6 in this way.. But now..
# echo "deb http://repo.mysql.com/apt/debian/ $(lsb_release -sc) mysql-5.6" >> /etc/apt/sources.list && echo "deb-src ...
0
votes
1answer
17 views
Backup mysql database via sftp
I have recently messed up my debian server and I have only sftp access for my files.
I rescue almost everything except of my database.
I have no longer direct ssh access, other than in rescue mode, ...
0
votes
2answers
30 views
Tab completion does not work in MySQL command line client
I've installed MySQL 5.7.10 on my Mac using Homebrew. My Mac is running OSX 10.11.3.
When I'm running the MySQL command line client, I cannot tab-complete keywords, table or column names.
How do I ...
1
vote
1answer
34 views
curl: (77) pbm with the SSL CA cert (path? access rights?)
I am in root in my directory on CentOS release 6.6 and I want to do the following in order to install mysql in upper version on centOS:
rpm -Uvh ...
0
votes
1answer
43 views
Verifying output of a command not quite working via BASH script
In attempting to verify if a remote database exists or not, I'm seeing mixed behavior with a conditional statement.
Technically the statement is working (it correctly reports if database is found), ...
0
votes
1answer
26 views
Reroute mysql connection through external machine
I want (as a first step towards an external mysql proxy) reroute traffic from the local connection of mysql (on a VM) to an external proxy (on the host) which then routes it back to the VM which will ...
0
votes
2answers
36 views
How to automatically feed two arguments to program after startup? [duplicate]
I have this following script which works fine on ubuntu for starting and creating a new table for MySQL database:
echo "CREATE DATABASE database_name" | mysql -u root -p
After this command is ...
0
votes
2answers
33 views
how to create table with fields in command line Centos
How do I do this in command line?
Below is code i saw imported to PhpmyAdmin but i don't use any interface...
CREATE TABLE IF NOT EXISTS `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
...
1
vote
1answer
26 views
Silent MySQL Server installation
I want to install a mysql-server on a Raspberry Pi (Debian) using a SSH-connection and a bash script, which contains the installation commands. The point is, that the installation need to be done ...
1
vote
0answers
46 views
Systemd: Running a script before msyql stops on shutdown
On my Ubuntu 14 vagrant box I use this upstart script to run automysqlbackup on every vagrant halt:
description "run automysqlbackup"
start on stopping mysql
task
exec automysqlbackup
So ...
0
votes
0answers
11 views
How to configure sympa with plesk root access using mysql usename admin@localhost?
I'm trying to use MySql, but username is admin@localhost. It was root but plesk changes it to admin. I also tried PostgreSQL but after it asks for the root password there is another request to access ...
0
votes
2answers
52 views
Mysql server not starting
I installed Mysql server 5.7.9 on RHEL 6.5 using mysql57-community-release-el6-7.noarch.rpm Repo. And installation was successfull but when i try to start it up and gives errors. And from ...
0
votes
0answers
20 views
Monitoring mysql with munin - worse MySQL performance?
If I monitor my MySQL server with munin, can I envisage with worse MySQL performance? When I want to activate statics as an example in PHPMyAdmin it says that the MySQL performance can be inferior as ...
0
votes
0answers
16 views
MySQL Cluster node crashed, how to re-add in cluster?
We have 2 data node in mysql cluster, and one of them got crashed (totally). I have re-install new OS and now i want to re-add same node back to cluster. How to do that without re-starting whole ...
-2
votes
1answer
23 views
Executing MySql stored proc in Crontab [closed]
I have a MySQL stored proc named "item" and I want Cron to run it for me - in server of course. I'm avoiding using MySQL events to unify all my 'jobs' - backup,etc.
Any how this is what I did in my ...
2
votes
2answers
402 views
Debian 8 - Install lastest version of MySQL
After downloading MYSQL APT Repository at
http://cdn.mysql.com//Downloads/MySQL-5.7/libmysqld-dev_5.7.11-1debian8_amd64.deb
I ran the command
dpkg -i libmysqld-dev_5.7.11-1debian8_amd64.deb
...
1
vote
2answers
51 views
MySQL Access Denied (CentOS)
I have installed fresh MySQL server on CentOS, and started the MySQL server service with command.
# /sbin/service mysqld start
I checked the service and it is running.
Currently I am logged in as ...
2
votes
3answers
38 views
How to automatically handle low disk space?
Currently one of our prototypes has a very bad caching system.
In a matter of minutes it fills up it's harddrive and makes the system unusable.
What I need to do then is to restart mysql service to ...
0
votes
1answer
35 views
Sabayon 16 - MySQL Server unable to start
After installing Sabayon 16, I needed to install MySQL Server. I have followed two tutorials, but both of them fails to me. The first tutorial says to install dev-db/mysql and then execute sudo ...
1
vote
1answer
46 views
copy and symlink mysql to another disk partition
I'm using ubuntu 12.04 and have two disk partition named: /dev/sda and /dev/sdb.
my home partition and other programs are in /dev/sda.
therefor any work like database benchmark on my mysql databases ...
0
votes
1answer
87 views
limit of open files: Debian Jessies´ MySQL vs Community Oracle MySQL
I have just upgraded from MySQL Jessie 5.5 to MySQL Oracle Community Edition v5.6.
I have a particular MySQL server, that has around 230 DBs, and > 32k files/tables.
Whilst for two or three years, I ...
0
votes
1answer
17 views
unlang: sql results to local variable
I'm trying to save a resultset of a SQL query in unlang. (First time unlang for me by the way, so please don't judge me for mistakes)
The corresponding line is
Sql-Result-Set = %{expr: ...
0
votes
1answer
72 views
How do I prevent crashing my ec2 micro instance mysql db?
I have an Amazon ec2 micro instance that holds a WordPress site. Since yesterday, my mysql db keep crashing saying:
[ec2-user@ip-xxx-xx-xx-xxx ~]$ sudo service mysqld status
mysqld dead but subsys ...
0
votes
1answer
220 views
run multiple instances of MySQL CentOS7
I need to have multiple instances of MySQL running on my PC.
I did this:
yum install mariadb-server mariadb => install mysql
mysql_install_db --datadir=/var/lib/mysql => use mysql_install_db ...
2
votes
0answers
16 views
PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24) [duplicate]
I am getting this error message when trying to access a php page:
PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24)
How can I solve this ...
0
votes
1answer
27 views
mysql error.log centralize logs
I'm developing a script where it will look into logs every 10 minutes and if there's any critical error it will send an e-mail to a certain adress. I have this problem i would like to solve more ...
1
vote
1answer
758 views
MySQL Workbench warning when connecting to MariaDB
When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning.
Is this expected?
Incompatible/nonstandard ...
-1
votes
2answers
86 views
MariaDB: Create and grant a new user using unix sockets plugin (passwordless)
I just installed MariaDB on Kubuntu 15.10. I am able to log in with the root user via the plugin that authenticates the user from the operating system. (This is new to me, so I am learning about it ...
0
votes
1answer
506 views
mysql-workbench error while loading shared libraries (libzip.so.2)
I'm trying to use mysql-workbench on my Fedora 23 machine but it fails.
When I try to start it, I get the following message:
[daniele@localhost ~]$ mysql-workbench
...
1
vote
1answer
155 views
How to install a newer version of mysql workbench than is available in my distro's repos
I'm guessing this will be a quick fix for you. I am trying to install a version of mysql workbench that is NEWER than what is available to me through the regular debian repos.
I started by adding ...
0
votes
0answers
40 views
FreeBSD - slow remote mysql
I have classic webhosting and VPS with FreeBSD.
The website is on webhosting and mysql server is on VPS. When I try to remotely connect from webhosting to mysql server, page is loading very very slow ...
0
votes
0answers
45 views
The curious case of high 5 min load average
Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server.
Linux CentOS 6 Apache 2.4 PHP 5.5
I've been receiving tons of high 5 ...
1
vote
1answer
111 views
MariaDB - dependency problems - leaving unconfigured
I have tried to install ISPConfig3 on Debian Jessie 8.1, and it couldnt connect to mySQL (mariaDB 10.1). So I CTRL+C to kill the install and I tried to manually login to mySQL, but I failed. It was ...
0
votes
1answer
27 views
mysql monitoring tool
Is there any monitoring tool for mysql which will send a notification mail to mentioned email ID ?
It must monitor below parameters.
1. mysql more than 500 concurrent connections.
2. mysql deadlocks. ...
0
votes
1answer
217 views
Failed to open the bootstrap file in MySQL
After doing an installation of MySQL Ver. 5.7.10 for RH/Oracle Linux I get an error that during the initialization the bootstrap file was not found. I'm not sure where this may come from, as it is a ...
0
votes
1answer
18 views
stop unknown instance for mysql
I have to reset a mySQL root password but when I try to run this command:
sudo stop mysql
and it outputs: stop unknown instance
1
vote
0answers
85 views
Reducing Number of MariaDB/MySQL Threads
So I'm running a MariaDB 10 database on a single core server; not super powerful, but then my needs aren't huge either.
However, one thing I've noticed is that if I look in htop I have around 28 ...
0
votes
0answers
73 views
Installing mysql-server always prompts me to configure mysql-server-5.5
This is so confusing, I am trying to install mysql-server using this command sudo apt-get install mysql-server but it displays these lines
Reading package lists... Done
Building dependency tree ...
2
votes
1answer
24 views
Postfix database unreachable behaviour
I have a server running postfix and dovecot with a local mysql database to store virtual domains and users. I'm considering to move the database to another server and perhaps switch to using ldap ...
1
vote
1answer
362 views
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I am trying to copy data from CSV to mysql using shell script where I am all new. And I am working with my test server.
mysql -u root -proot csv_imports -e "LOAD DATA INFILE ...
1
vote
1answer
254 views
mysql-server-5.5 unmet dependencies each time running apt-get
Each time I run "sudo apt-get install package-name", the following error happened, even if I tried to install other packages other than mysql ones:
You might want to run 'apt-get -f install' to ...
1
vote
1answer
82 views
How to use SSH tunnel to connect to remote MySQL server?
I am trying to connect to remote MySQL server, which runs on CentOS 6.6 cPanel server.
I am creating tunnel this way:
ssh -L 3306:xxx.xxx.xxx.xxx:3306 [email protected] -p PPPPP
Where ...
1
vote
1answer
19 views
Install mysql-workbench in fedora 21
I already install mysql-workbench in fedora 21 from rpm:
yum localinstall mysql-workbench-community-6.3.5-1.fc21.x86_64.rpm
But when I tried to launch apps by command:
/usr/bin/mysql-workbench ...
0
votes
0answers
14 views
Allow non-localhost access mysql [duplicate]
I have been researching how to find a way to let non local host access mysql server, and I was looking at a few things online and so far what I have found is people saying to edit my /etc/mysql/my.cnf ...
