An open-source, relational database management system.
0
votes
2answers
34 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
31 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
23 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 ...
-3
votes
0answers
21 views
1
vote
0answers
29 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
10 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 ...
-2
votes
0answers
20 views
My File Rights Are Messed up!
For homework I need to manually make an LAMP server (i am a beginner) I did the installation and configuration of Apache, Mysql and php with my "root" user and then after that i came beware of errors ...
0
votes
2answers
32 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
13 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
14 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
19 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
174 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
1answer
38 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
31 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
0answers
13 views
What are the minimal MySQL grants for the debian-sys-maint user? [migrated]
What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly?
This answer on ServerFault suggests granting RELOAD only, but this is incorrect, as it ...
0
votes
1answer
23 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
30 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
56 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
0answers
19 views
MySQL Bin-Log Courupped [migrated]
In the recent time we have found that the bin log is getting corrupted, 20% binlog files were having errors, which couldn't even pass the sanity check by mysqlbinlog -u user -p mysql-bin.000021 | head ...
0
votes
1answer
15 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
46 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
77 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
23 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 ...
0
votes
0answers
426 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
49 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
311 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
66 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
35 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
43 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
76 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
180 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
14 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
56 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
57 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
21 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 ...
0
votes
1answer
220 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
139 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
70 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
18 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 ...
1
vote
0answers
56 views
Debugging Slow Queries in MariaDB/MySQL
I've set up a MariaDB server and everything is running well, with most queries executing in well under 20 milliseconds, but every so often a query will take half a second or longer (sometimes several ...
0
votes
2answers
23 views
Import New Database Into MySQL
I have to set up a local database on a number of people's Linux Mint lap- and desk-tops. The idea is to do this from the command line after installing MySQL Server and Client, and associated ...
1
vote
0answers
162 views
MariaDB Dependencies issue after isntall/remove
I tried to "upgrade" MySQL 5.5 to MariaDB by removing MySQL altogether. Then I installed MariaDB 10.1 as follows:
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys ...
1
vote
0answers
86 views
Mysql 100% 1 core CPU load
I have 8 cpu in server, and Mysql works only on 1 cpu core on 100%.
How can I use all cores?
my my.cnf
[mysqld]
safe-show-database
query_cache_limit=1M
query_cache_size=64M ## 32MB for every 1GB ...
1
vote
1answer
220 views
Mysql Isn't starting
I recently asked this question the reason mysql wasn't starting is because there was no disk space. After a long discussion with casey in chat room and after following his answer, I freed about 10 GB ...
0
votes
0answers
45 views
Linux huge IOPS difference - same disks
I've been investigating for some time regarding some IOPS issues I've been experiencing.. And my mind is getting crazy!
I have two servers (one bought 2 weeks ago, another 1.5 years ago) that I ...
0
votes
1answer
56 views
Linux Mint 17 Cinnamin + MySQL + turn OFF autostart
I have tried all the suggestions in hours of googling and still when I reboot and run service mysql status my server is running. since i only use mysql for database testing with my java apps i don't ...
0
votes
1answer
54 views
get mysql count of id in shell script
I am trying to get count of column user_Id using count(user_Id) from mysql as follows:
count=$(mysql -uroot -proot csv_imports -e "select count(user_Id) from test_data where user_Id=\"12345\";")
I ...
