Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
13 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
14 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
5 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
29 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
15 views

How to configure bind,apache and Joomla [on hold]

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
12 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
44 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
373 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
18 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
21 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
10 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
13 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
20 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
40 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
31 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
23 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
64 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
19 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
25 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
47 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
34 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
63 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
40 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
29 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
56 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
44 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
55 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
32 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 ...
0
votes
0answers
16 views

MySQL Connector/C++ can't be installed due to a dependency

I'm trying to install MySQL Connector/C++ into Ubuntu and the apt-get complains about Boost Ver 1.53, which is not installed on my system: mylogin@ubuntu:/usr/include/boost$ sudo apt-get install ...
1
vote
2answers
48 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
81 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
87 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
71 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
27 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
42 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 ...
0
votes
1answer
34 views

How to add apache2 , php and mySql to eclipse?

I'm using Ubuntu 14.04 ,i'm new to Ubuntu,I already installed apache2 , php and mySql . Now I want to add these to eclipse so that I can work on this IDE . Please help me I will be glad if you provide ...
-1
votes
1answer
23 views

Connect to mysql on another device [duplicate]

I have two device on my network LB (192.168.1.10) and RP1 (192.168.0.20) I am wanting all the MySQL stuff to be hosted on the LB and all the web stuff to be hosted on the RP1. I have installed ...
1
vote
2answers
81 views

Installing MySQL on Ubuntu creates kworker/systemd-udevd blocked for more than 120 seconds

I've tested it twice. First time was on Ubuntu 12.04 with MySQL 5.5. Now I've tried it on Ubuntu 14.04 and MySQL 5.6. Both were fresh installs. Right after MySQL finishes installing, I begin to get ...
0
votes
1answer
20 views

Major Server Issue

lately I have been loading my website, and almost every time I do (once or twice a day) the message: "Error establishing a database connection". I have resolved it temporarily by stopping and starting ...
1
vote
2answers
71 views

How to connect to db4free database using 'mysql' command from the terminal

I am running MySQL 5.5 on Ubuntu 14.04. I can open and work with local databases using mysql in the terminal. I can also run phpMyAdmin and access the database on db4free.net on the browser. However i ...