Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
9 views

Ubuntu php and apache development!

I heard that Ubuntu has already available for installation packages as well , confirmed and it really is true , just installed that came with php5.5 , I need php5.2.17 for installation of vBulletin my ...
0
votes
0answers
11 views

Problem with MariaDB! [on hold]

I have a really big headache with Mariadb installation. I tried my best looking for a solution, trying to install it from repositories and installing from the tar.gz file, but I didn't get any ...
0
votes
0answers
47 views

MySQL breaks after upgrade from Ubuntu 14.04LTS to Ubuntu 15.04

I recently upgraded from Ubuntu 14.04LTS to 15.04 and during this upgrade, MySQL probably broke. After the upgrade, I ran the command(to start mysql): sudo service mysql start The result was command ...
1
vote
1answer
10 views

MySQL ERROR 13 (HY000) on database creation

The full error is: MySQL ERROR 13 (HY000): Can't get stat of './databasename' (Errcode: 13 - Permission denied) I can't create databases in the mysql shell. I can log in as root just fine and I've ...
-1
votes
0answers
9 views

Integration mysql with elasticsearch aws E2 Ubuntu instance?

I have installed elasticsearch and mysql on aws e2 Ubuntu instance. I have to integrate them can any one help me to integrate mysql and elasticsearch...
0
votes
0answers
61 views

Can't install mysql-server on Server 15.04

I have a fresh VPS at Digital Ocean, imaged with Server 15.04 x64. I'm trying to install mysql-server, but it errors out. Why is this happening? The only system configuration-related thing I did ...
0
votes
1answer
20 views

I can't install mysql on 14.04: “Unable to set password for the MySQL root user”

I have tried the solutions presented in Error installing mysql server on Ubuntu 14.04 but I still can't get it to work. The problem i think is when I install it asks me to set password, but then i ...
1
vote
0answers
16 views

phpmyadmin: unable to connect to 127.0.0.1

I recently installed LAMPP on Ubuntu 14.04. When I start/restart Apache on terminal it shows [OK] but phpmyadmin says "Can't establish a connection to 127.0.0.1". I have tried solutions provided in ...
0
votes
1answer
19 views

LAMP installation

I am trying to install LAMP server on my Ubuntu 14.10 but i am having a lot of problems: the first time i installed it i tried to run my website locally but i wasn't able to access the database ...
1
vote
0answers
10 views

Can't change open-files-limit for mysql on Ubuntu 14.04

I have a LEMP stack on Ubuntu 14.04 with MariaDB. Mysql is a huge bottleneck for my server. I have tried everything of which I am aware to raise the open files limit for mysql. I have added ...
1
vote
0answers
35 views

Systemd Mysql won't stop

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just ...
0
votes
0answers
18 views

How to configure bind,apache and Joomla [closed]

ifconfig eth0:0 192.168.201.x+1 netmask 255.255.255.0 Edit /etc/network/interfaces /etc/init.d/networking restart apt-get install apache2 create file in /etc/apache2/sites-available mkdir ...
0
votes
1answer
14 views

Bash sed to read auth into debconf-set-selections for Vagrant VM

I have a Vagrantfile that uses a bash script to set up a VM. I can't get the script to set a password for MySQL using debconf-set-selections with output from an .auth file. Below is an example of the ...
2
votes
1answer
65 views

Upgrading MySQL 5.5 to MySQL 5.6 on Ubuntu 14.04 LTS

I have installed my LAMP with the following commands: sudo apt-get update sudo apt-get install apache2 apache2-suexec mysql-server php5-mysql sudo mysql_secure_installation sudo apt-get install php5 ...
1
vote
2answers
519 views

How to get mysql-server setup on Ubuntu 15.04?

When I was upgrading from 14.10 to 15.04 my mysql somehow broke. When I run sudo dpkg --configure -a After a long wait I get the following response Setting up mysql-server-5.6 (5.6.24-0ubuntu2) ...
0
votes
0answers
20 views

Not Connecting to MySQL database on server [on hold]

I am trying to connect to a database with the Help of SQLWorkbench/J, all the information that I have entered is correct, but I don't know how to set the URL. The URL which I am using is ...
0
votes
1answer
25 views

Reset password for mysql in ubuntu: [duplicate]

Refer from this question (Resetting forgotten phpmyadmin password) I am trying to reset the password of mysql installed.But run the third command mysql -u root mysql i will get the error ERROR 1045 ...
0
votes
0answers
13 views

MYSQL How to delete and set permissions to root@localhost

I have a problem using mysql, I keep getting this error message for the root user (access denied) : julian@julian-desktop:~$ mysql -u root ERROR 1045 (28000): Access denied for user ...
0
votes
0answers
16 views

Load balancing apache (Linux) with IIS (Windows)

I've got a server (Linux) with Apache2 (2.4.7), Phpmyadmin VSFTPD and Wordpress, a second Linux server with MySQL running alone and a Windows machine with IIS and Wordpress running. I'm looking to try ...
1
vote
1answer
12 views

An error with MySQL

An exception occurred: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) This is what I get when I try to visit one site! The question is: is it releated to my ...
1
vote
1answer
26 views

MySQL broken. Plugin “FEDERATED” is disabled. Plugin “InnoDB” is disabled

I seem to have horribly broken MySQL on our Ubuntu 14.04 LTS server. We recently installed the mysql-proxy package(we've been trying to set up master-master replication, but we've abandoned that for ...
0
votes
1answer
44 views

How to disable autostart for a mysql?

How to disable autostart for a mysql? I was run sudo update-rc.d -f apache2 remove After it I looked throug all rc0.d - rcS.d and nowhere have found a mysql file. However, the mysql server starts ...
0
votes
1answer
34 views

How to remove MySql apt repo

I was trying to install MySql on my system running Ubuntu 14.04. So I added a MySql apt from the link Steps to fresh install MySql After running into a lot of trouble and realizing the apt uses libs ...
0
votes
0answers
28 views

Installing wordpress with remote access

Probably a very easy question to solve, but is there any recent information on how to install wordpress with remote access? I've found a few online but they're all a few years old and giving ...
4
votes
1answer
39 views

How to find the site that crashes the server?

Probably 1 out of 100 sites crashes the VPS every few days. Apache connections go to few hundreds and mysql requests to few millions. That causes the CPU to be at 100%+ permanently and making the ...
1
vote
4answers
73 views

Unmet dependencies unable to fix

I'm running ubuntu 14.04. I cannot use software center to install anything, even a local deb package so I have to rely on Terminal. Recently I was trying to install mysql-server which generated error ...
1
vote
2answers
21 views

how to use mysql with less and -F

I want to use less as a pager for mysql client. I want to add -F to force quit for short outputs. But I can't combine both correctly. root@jupiter:/# mysql -p -u root -h localhost --pager=less -F ...
1
vote
1answer
26 views

unable to excecute mysql from command line

I've installed xampp. I want to use mysql only and i want to use it in command line not in php myadmin. how can i do that? I've installed mysql again with sudo apt-get install mysql....5.5 so I've ...
1
vote
0answers
31 views

Can`t reinstall mysql on kubuntu

Every time I try to install MySQL I get Setup package mysql-client-5.5 (5.5.41-0ubuntu0.14.04.1) … Setup package mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) … 150415 15:35:15 [ERROR] Can't find ...
0
votes
1answer
48 views

Building ubuntu touch app with sql (mysql) support problem

i`m trying to develop simple ubuntu application. This application should connect to remove mysql server, query and display data in UbuntuListView. Project was created in Qt Creator 3.1.1 as QML app ...
2
votes
1answer
36 views

mysql and do-release-upgrade

Could someone tell me what happens to mysql databases when you run a do-release-upgrade? When I do the dry run for do-release-upgrade I see that it will uninstall mysql client and server and install ...
0
votes
0answers
69 views

http://localhost/phpmyadmin Not found

I have tried to run myphpadmin and I get this message: Not Found The requested URL `/phpmyadmin` was not found on this server. Apache/2.4.10 (Ubuntu) Server at localhost Port 80 I have reinstalled ...
0
votes
3answers
44 views

cant remotely connect to mysql

I've got a 3 servers & 1 windows machine running in a LAN HTTP server (Apache2, PHP5 & phpmyadmin) - 10.0.0.10 DNS - 10.0.0.1 MySQL - 10.0.0.40 Windows - 10.0.0.157 i've just installed a ...
0
votes
1answer
30 views

Can't install phpmyadmin on ubuntu 14.04+apache2

I installed phpmyadmin via sudo apt-get install phpmyadmin but here what gives me http://localhost/phpmyadmin/: php5, phpmyadmin etc. modules are activated for apache. How can I fix this?
0
votes
0answers
65 views

Unable to access phpMyAdmin remotely

I've got a 3 servers & 1 windows machine running in a LAN HTTP server (Apache2, PHP5 & phpmyadmin) - 10.0.0.10 DNS - 10.0.0.1 MySQL - 10.0.0.40 Windows - 10.0.0.157 I'm currently trying to ...
2
votes
2answers
46 views

Automate user creation [closed]

I have a site for my students, and it is running on Ubuntu 14.04. When my students register themselves on my site, I store user info in an MySQL DB. I would like to give my students a website on my ...
0
votes
2answers
64 views

Installing MySQL Workbench ⇒ Error

I have installed MySQL Workbench in the past using MySQL APT. My software repositories lists have recently been updated and since then my MySQL Workbench disappeared. It is still on the disk but it ...
0
votes
0answers
33 views

MySQL service status shown as not running with --status-all

I'm having a problem with my mysql server which does not seem to work properly. On Ubuntu 14.10 I run service --status-all and get [ - ] mysql However, after service mysql status I receive mysql ...
1
vote
1answer
15 views

Mysql failure packages

root@dedi-fr-36189:~# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean ...
1
vote
2answers
50 views

Connecting phpmyadmin to seperate mysql server

I've got what's probably a very easy question to solve, but I've been stuck on it for a few days now. I've got 3 servers running in a small network, DNS, HTTP and MySQL. I've got apache2 and PHP5 ...
-1
votes
1answer
18 views

not able to connect to phpmyadin

The apache server stopped and lamp is started. The terminal shows lamp server is working fine but not able to enter phpmyadmin
0
votes
0answers
16 views

dpkg: error processing php5-mysql (-configure): the thread installed the script post-installation error 10 exit code returned

I'm trying to install php5-mysql but when I put the command apt-get install php5-mysql I get this error of dpkg. http://pastebin.com/ZEn4fydB Note: the operating system is in Spanish.
-2
votes
1answer
103 views

root@controller:~# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Running 14.0.2 LTS version Server restarted and I was not able to access MYSQL root@controller:~# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
94 views

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused

I have a different server for my database. When I connected to database with PDO, I used the IP address of database VM for host parameter: $dbh = new ...
0
votes
1answer
74 views

Access Denied for user 'linuxuser'@'localhost' (using password: no)

My client asked me to move his Wordpress site from a shared server to AWS. The AWS EC2 instance is Ubuntu 14.04 LTS with PHP 5.5.9 with MySQL 5.5.38. Old server has PHP 5.4.30 and MySQL 5.5.42. ...
-1
votes
1answer
16 views

custom kernel for secure system

I am pretty new to the linux community and I've started learning it for last few months. After learning the basics of commands and system architecture im now trying to learn the grass root level ...
-1
votes
0answers
28 views

http://localhost/bugzilla/ -— Not working

Reading ./localconfig... Checking for DBD-mysql (v4.001) ok: found v4.025 There was an error connecting to MySQL: Access denied for user 'bugzilla'@'localhost' (using password: ...
0
votes
0answers
46 views

apt-get install problem with MySQL Ubuntu 12.04 [duplicate]

I have a working system with Ubuntu 12.04 and LAMP For some reason i am unable to install any new software on system. Every time I try to use apt-get install i get the following error: Example: ...
1
vote
1answer
23 views

where to save your files of php in ubuntu to load on server? [duplicate]

How to save our php files so that we can load on our server . I have installed apache2 , php, and mySql . also I don't know how to connect these 3 so that I can simply work on my text editor. Please ...
0
votes
1answer
45 views

Reinstall of mysql server hangs

I am trying to reinstall mysql-server-5.5 because mysql server would not start. I purged everything but the install fails I am trying to reinstall using sudo apt-get install mysql-server-5.5 and it ...