Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
4 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
38 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 ...
1
vote
1answer
781 views

Error installing mysql server on Ubuntu 14.04

I am getting error installing mysql on ubuntu desktop 14.04 ( 64-bit) I used following command sudo apt-get install mysql-server It asked me for password (and verfication) and ended on follwing ...
0
votes
1answer
17 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 ...
0
votes
1answer
37 views

unsure of owncloud mysql password and database

I've recently attempted to make my pc an owncloud server. I attempted to logon on the same machine I am hosting it on. However, I first need to enter a mysql password, database name, etc., and I don't ...
3
votes
1answer
3k views

Unable to re install mysql on Ubuntu 14.04: Dependency problems

Ubuntu Unity 14.04 LTS with all lenses removed, except files. (Hate the dash.) I have a LAMP system for web site development. I want to put all my data files in a particular partition that I can ...
-1
votes
1answer
2k views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...
1
vote
0answers
15 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
7 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 ...
2
votes
1answer
1k views

Where is mysqldbcompare?

The MySQL docs refer to a utility mysqldbcompare. But it doesn't seem like I have it installed, and when I type mysqldbcompare it doesn't suggest any packages (Ubuntu 12.04). Where can I find this ...
0
votes
1answer
1k views

phpmyadmin not working because i changed permissions and don't know how to change it back

I installed LAMPP and it worked fine, but i somehow managed to change the permission of the folder /opt/lampp/ to 777 by using this command sudo chmod 777 -f /opt/lampp -R My plans was to do: ...
6
votes
7answers
17k views

Where is my phpMyAdmin installation?

I just finished installing mysql-server, and then installed phpmyadmin which came with Apache and PHP. It set it up alright and made a phpMyAdmin database, but I can't seem to find the URL to get to ...
0
votes
0answers
112 views

MySql crashes happening daily after ubuntu system updates

I have been having this issue for sometime and have no idea why it happens or how to fix it. I'm a Linux novice so that doesn't help. I have a server running on AWS and s used only for hosting ...
2
votes
1answer
1k views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
2
votes
1answer
53 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 ...
4
votes
4answers
9k views

'Unable to set password for the MySQL “root” user' on a Openvz VPS

I'm trying to install mysql server on my Openvz based VPS running Ubuntu 13.04 64bit and i keep getting this error at the install. I tried multiple times and i also re installed the os with no change ...
3
votes
3answers
16k views

The phpMyAdmin configuration storage is not completely configured

I typed apt-get install phpmyadmin and ran into an error saying it cannot connect to mysql (socket issue). It was normal because I forget to install mysql before, so I selected "abort" above all ...
1
vote
0answers
33 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 ...
4
votes
2answers
3k views

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different ...
0
votes
0answers
16 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 ...
4
votes
7answers
12k views

MySQL error: The partition with /var/lib/mysql is too full!

I get this error when trying to start MySQL: The partition with /var/lib/mysql is too full! Here is the output of df -h: Filesystem Size Used Avail Use% Mounted on /dev/sda1 455G 77G ...
0
votes
1answer
13 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 ...
3
votes
1answer
7k views

“Can't create test file /var/lib/mysql/user-desktop.lower-test”: How to run mysql server on Xubuntu 13.04 (kubuntu-desktop)

I have downloaded and unpacked MySQL 5.6.12 to /opt/mysql/server-5.6. I want to use this db instead of pre-installed 5.5 version. But neither version works. When I want to start a server with mysqld ...
1
vote
2answers
448 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 ...
1
vote
1answer
21 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
23 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
1answer
43 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 ...
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 ...
0
votes
0answers
12 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 ...
0
votes
2answers
353 views

debian.cnf file location in Ubuntu 14.04

Where can I find the "debian.cnf" file in Ubuntu 14.04? It was under "/etc/mysql/debian.cnf" in Ubuntu 12.04. Is there some location changes or name changes ? What I want is to reset MySQL root ...
0
votes
1answer
5k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
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 ...
2
votes
2answers
45 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
1answer
4k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...
1
vote
1answer
11k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld ...
0
votes
0answers
26 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 ...
0
votes
2answers
4k views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
1
vote
2answers
1k views

Problems installing mysql on Ubuntu 14.04

I hit the following error shortly on entering the mysql "root" password: An error occurred while setting the password for the MySQL administrative user. This may have happened because the account ...
0
votes
2answers
633 views

How to make a Portable Server for ubuntu?

I want my server to be portable so it will be available everywhere when I plug it in to other ubuntu computers. Like I want to use it at school, I will just have to run a script and the server runs. ...
1
vote
4answers
66 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
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
22
votes
4answers
215k views

How to change root password for mysql and phpmyadmin

I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin: Login ...
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 ...
4
votes
2answers
1k views

Is there a Linux equivalent to LinqPad?

I've recently been finding myself writing more SQL, on Windows with MSSQL and LinqPad and while I want to experiment on Ubuntu to get more of a handle on databases and I have no love lost for MSSQL, ...
1
vote
2answers
20 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 ...
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 ...