An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
2k views

Why don't I see the XAMPP page on Linux Mint?

I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this: Instead, I see: It works! This is ...
2
votes
3answers
4k views

Troubles installing php with MySQL support

So I wasn't sure if this question would go best here or on Overflow or Server Fault, but decided to try here first. I'm installing LAMP on a VPS, and am running into issues configuring and building ...
0
votes
2answers
287 views

Linux (Debian) web server advice [on hold]

I'm at the start of a new company in which the main activity is building internet web apps. I was very familiar with linux 8-9 years ago, but since then, I've lost a lot of touch with it (couldn't ...
2
votes
0answers
29 views

apt-get commands won't return

I am working on a Raspberry Pi running Raspbian, and I think I'm having a problem with my apt-get. The problem originated with a MySQL server I was running. The server stopped seemingly at random, ...
0
votes
0answers
13 views

Log Slow Query not working

I'm trying to log slow query, here's my mysql config on /etc/my.cnf: [mysqld] slow_query_log = 1 slow-query_log_file=/var/lib/mysql/slow_queries.log long_query_time = 5 log_queries_not_using_indexes=...
-1
votes
0answers
24 views

unable to insert a row in mysql [migrated]

I am using LAMP server and a PHP script to connect to an existing Mysql server (local server i.e. host=localhost:3036). I have created a table called depositor using $sql2="create table depositor(...
0
votes
1answer
366 views

Disable MySQL startup in Linux

I have KDE, and it has software to manage startup packages. But, I don't see any mysql, mariaDB or mysqld service. How can I disable or prevent the mariaDB and mysql daemons from starting ...
0
votes
1answer
2k views

Getting Minor Version Mismatch Error with Php and Mysql

I randomly started getting this error when trying to instantiate a new mysqli instance in php script: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50541 Library:...
1
vote
2answers
2k views

Installing MySQL on CentOS throws error that cannot find mysqld.sock

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld....
0
votes
1answer
22 views

How can I get Wordpress functioning from its new address?

I have a Wordpress installation which I wish to redirect from http://dev.example.com to https://example.com I can get an unstyled page like the below; the browser balks at loading HTTP content for an ...
0
votes
1answer
19 views

getting started with lamp server [closed]

I have successfully installed LAMP server on my machine running Ubuntu 14.10. Now, there is a location /var/www/html/. In this directory, I am supposed to place the HTML files and php files that I ...
5
votes
3answers
264 views

How to change MySQL 'root' password using MySQL v5.7?

Current Environment : mysql> show variables like "%version%"; +-------------------------+------------------------------+ | Variable_name | Value | +---------------...
-3
votes
0answers
17 views

PHP application mysql giving error

Got the below error while implementing this. I have done every thing which is mentioned in the document, but still I get this error, previous implementation is working fine. The following error ...
0
votes
2answers
50 views

How to install specific mysql 5.6.21 version on redhat?

My requirement is Mysql 5.6.21. I tried to install Mysql but it installed 5.6.31 version. I tried following steps: $ yum repolist all | grep mysql It gives following output: mysql55-community/...
0
votes
1answer
1k views

PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/php_mysql.so'

I am running PHP 5.6 on Linux. When I try to load a PHP page, I'm getting the following PHP error. PHP Startup: Unable to load dynamic library /usr/lib64/php/modules/php_mysql.so' When I look ...
3
votes
4answers
6k views

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

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: mysql-...
0
votes
0answers
52 views

yum install error nothing to do (MYSQL, CentOS 7)

I'm trying to install MYSQL instead of MariaDB on my VPS CentOS 7. I used this command: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm yum install http://dev.mysql.com/get/mysql-...
1
vote
1answer
1k views

Mod_Auth_MySQL will not compile under Slackware 13

I tried to add the auth_mod_auth (3.0.0) module to my Slackware 13 (apache 2.2 & MySQL 5.0) system. I ran the usual command line for apxs (as mention in the BUILD file) apxs -c -L/usr/lib/mysql -...
0
votes
1answer
936 views

Sending emails from AutoMySQLBackup from Linux Mint

I have set AutoMySQLBackup on a Linux Mint machine and I want to have the backups sent to an email, but I cannot make it work. I'm new to Linux environment and don't understand it very much. I ...
1
vote
1answer
3k views

MySQL aborting during initial db installation

Linux version: shell> cat /proc/version Linux version 3.2.0-4-686-pae (debian-kernel@lists.debian.org) (gcc version 4.6.3 (Debian 4.6.3-14) ) #1 SMP Debian 3.2.46-1+deb7u1 Installing MySQL 5.6....
1
vote
1answer
1k views

phpmyadmin doesn't work after installing php5-mysqlnd

I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute ...
0
votes
1answer
47 views

Install mysql-server 5.6 on Debian Wheezy

I had a messy mysql installation on my Debian server. I got rid of everything using the dpkg --force all --purge packet on any mysql packet I could find (mysql-common, mysql-server, mysql-client, ...
5
votes
1answer
866 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
1answer
49 views

CentOS define same date and timezone for system and MySQL

I was watching that my droplets have different timezone between OS and MySQL. By default, I've configured all vms to Brazilian timezone (America/Sao_Paulo) through tzselect, and, assuming that MySQL ...
1
vote
1answer
19 views

PHP does not use MySQL default sockets

I am having a hard time understanding why PHP cannot connect with localhost as a host. I can connect by doing: mysql -uroot -p And also, through Sequel Pro I can connect with localhost as a host. ...
0
votes
1answer
25 views

Couldn't connect to Larvel homestead database with MYSQL workbench

I am unable to connect to laravel homestead via mysql workbench here is how i connected but i am facing the below issue Plz Plz help me !!! Edit: Here are the details as requested by Gerath ...
2
votes
1answer
1k 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
0answers
8 views

Pmacct resource usage and remote data push capability

Firstly, I am interested in hacking pmacct into some Asus router firmware (n14U). I will build it from source, etc so that should be big deal. However, I am a little concerned about the resource usage ...
1
vote
0answers
36 views

Using yum to upgrade from MySQL 5.1.73 to 5.7.13

I've picked up an IT role and I'm new to yum so please forgive me. yum list shows these mysql packages installed: mysql.x86_64 5.1.73-5.el6_6 @base ...
4
votes
1answer
3k views

How can I fully remove a tablespace from MySQL?

I have a MySQL database called camera_main_live, which I administer using Adminer. It is, to all appearance, empty. So when I want to add some content, I begin by running this script (with Adminer set ...
1
vote
1answer
24 views

Munin mysql plugin silently fails

I installed this Munin MySQL plugin on a RHEL 6 machine and I'm experiencing a strange behavior. I'm not getting any data in the Munin web page (the Categories list does not show a mysql link), but ...
1
vote
1answer
180 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 ...
3
votes
2answers
2k 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 ...
0
votes
1answer
795 views

error on opening mysql workbench on fedora 23

I have installed mysql-workbench on Fedora 23 Virtual machine (VMware) using the command : yum install mysql-workbench Now when I tried to issue the command mysql-workbench from terminal I am ...
4
votes
0answers
115 views

Using a NFS for gcc, Apache, PHP, MySQL, glibc

I have 7 SLES VM. I am compiling always the newest version of gcc and all dependencies. Apache and all dependencies. PHP and all dependencies. MySQL and all dependencies. glibc and all dependencies. ...
2
votes
1answer
26 views

MySQL command line - bind <UP> key to a backward command search

With mysql command line client on Ubuntu 14.04 I could bind UP to a backward command search by adding the following lines to ~/.inputrc # type a word, hit up and a search is performed # "\e[A": ...
0
votes
0answers
14 views

How to force rsyslog ommysql use UTF8?

I'm using ommysql in rsyslog for transferring data into MySQL $ModLoad ommysql local6.* :ommysql:localhost,Syslog,rsyslog,1 but Cyrillic data goes like "·Ð¾Ð²Ð°Ð½Ð¸Ðµ иÑ�точнÐ" in ...
2
votes
3answers
68 views

Mysql output format in Bash Script

I'm writing a bash script where I'm using mysql query in that script where the format which I'm getting is quite different. Query: root@debian:~# mysql -u root -ptoor super_market -h 0 -e "select * ...
1
vote
6answers
893 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 ...
5
votes
2answers
2k views

Convert mysql count(*) to int in bash?

I'd like to execute this and check if count is 0, 1 or > 1 in bash. mysql -e "select count(*) from mydb.mydb;" The output is: +----------+ | count(*) | +----------+ | 0 | +----------+ I ...
2
votes
1answer
551 views

can not install mysql-server on centos 6.7 32bit . Error: need rpm?

when I try to install mysql-server on centos with this command: yum install mysql-server server replies: Loaded plugins: fastestmirror, security Setting up Install Process Loading mirror speeds ...
3
votes
2answers
8k views

Problem Starting MySQL on new Centos 6 build

I have a VPS with ChicagoVPS that's running Centos 6. Official version of the build is: Linux RedHat 6.5(Final 2.6.32-042stab078.26 x86_64) I followed this guide to add the repository and ...
1
vote
2answers
58 views

MySQL Daemon failed to start on centos

I installed MySQL 5.7 in my CentOS and tried to start the service but that gives this error. MySQL Daemon failed to start. Starting mysqld: [FAILED] mysqld....
1
vote
2answers
144 views

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

I have an 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 ...
4
votes
1answer
223 views

How do you give a developer group access to apache, MySQL, php and the webroot?

We have 3 web designers that are currently logging in to our server via root to configure apache and setup websites. I have very basic linux knowledge (I'm a web designer) and have created users and ...
5
votes
1answer
4k views

MySQL stop/waiting issues; “can't connect … through socket” [duplicate]

So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new ...
3
votes
1answer
162 views

How to interpret the following pattern of uptime data?

I have a small web server running mysql and wordpress which after a while appears to stop processing web requests. I can't even log into the server via ssh as ssh client times out when trying to ...
4
votes
2answers
13k views

PHP on centos 6 not working

I have installed PHP, MySQL, Apache on CentOS 6, now I have restarted the Apache and mysql, to test PHP I have created a index.php on /var/www/html/test/ now once I go to localhost/test/index.php then ...
4
votes
1answer
159 views

If I'm logged in as root, how do I restart mysql or apache with options?

I know the commands to restart/stop/start, but when I try to pass options it doesn't seem to work! CENTOS 6, MySQL 5.14 service mysql restart service httpd restart Then I tried this: /etc/init.d/...
0
votes
3answers
28 views

Does it matter if I'm root or not when installing apache?

I need to install a LAMP stack on a RHEL 6.7 server. Do I have to be root to install this or not?