Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
409 views

How to upgrade softwares from currently installed LAMP on a 64-bit Ubuntu 12.04 LTS system? Please provide me the step-by-step instructions

Someone had installed LAMP on my machine almost two(2) years back. I got this machine since last six(6) months. The LAMP is working fine for all of the PHP project work I do. But the issue is all the ...
0
votes
1answer
67 views

How to access MySQL after deleting all MySQL users?

I deleted all users by mistake and now I can't access MySQL. I searched too much but I can't access MySQL I can't remove it && reinstall again I delete all users from table user from database ...
1
vote
2answers
4k views

phpmyadmin not found

I am using ubuntu 14.04. I have made setup LAMP by going through step by step what in this link. For apache I mean http://localhost all the files are working fine . But when I am doing ...
1
vote
2answers
6k views

Forbidden You don't have permission to access /phpmyadmin on this server

I installed php, mysql, phpmyadmin on my Ubuntu 12.04 localhost in the following steps: I try these steps: sudo apt-get install apache2 sudo /etc/init.d/apache2 restart sudo apt-get install php5 ...
1
vote
1answer
399 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 ...
2
votes
0answers
407 views

MySQL Workbench on MySQL 5.6.19

I tried to install MySQL Workbench 6.1.7 on Ubuntu 14.04 after installing Mysql 5.6 library, but get the following: error: Package dependencies cannot be resolved This error could be caused by ...
0
votes
0answers
58 views

JUJU - deployed wordpress and mysql - Error establishing a database connection

After a week of deploying wordpress on juju with mysql, the site has gone down with the error: "Error establishing a database connection". Juju status is not working at all and I can't seem to ssh on ...
0
votes
0answers
203 views

Apt-get unmet dependencies

I´m using Ubuntu Server 12.04 and MySQL 5.5. When I try to install libsml2-dev I get the following message : root@myserver:/usr/local/php5516/php-5.5.16# apt-get install libxml2-dev Reading package ...
-2
votes
1answer
226 views

Database error. Wordpress. MySQL have shut down at 10:00 am

Could you please tell me what's wrong with my MySQL? Ubuntu 14.04. I can't understand what's going on.. 140912 10:00:55 [Warning] Using unique option prefix myisam-recover instead of ...
2
votes
2answers
3k views

“Rejected send message, 1 matched rules; type=”method_call“, sender=”:1.5“” while starting MySQL

I have a mysql that has been working fine but now will not start. All I've been able to accomplish is using sudo start mysql which generates the following error: start: Rejected send message, 1 ...
2
votes
1answer
118 views

Using libreoffice base as GUI for MySQL database (os- ubuntu 14.04) [closed]

I have been trying to deploy one of my projects that uses jsp for the front end, tomcat7 for the server and a mysql database. I tried integrating the mysql database with the libreoffice database ...
0
votes
0answers
59 views

PhpMyAdmin wont let me log in without password

I am preparing a Vagrant box to develop websites and I wanted to install phpmyadmin, to log in just as "root", no password needed, since it is just for development, but whenever I try it, I get the ...
0
votes
0answers
191 views

Skipping incompatible error when compiling mysql library using arm-linux-gnueabihf

All problems posted related to mysql library use standard gcc compiler. However, I need to compile a project running on a beaglebone black device. Hence, I am using arm-linux-gnueabihf-gcc instead of ...
-1
votes
3answers
162 views

What Is the Best UBUNTU script for installing LAMP [duplicate]

I have tried to install LAMP on Ubuntu 14.04LTS Cant get PHPmyAdmin to work and access MYSQL Where is the clearest set of instructions to install LAMP
0
votes
0answers
15 views

Remote access times out after update

Here is the situation: I have a MacBook which I use for all of my development and an Ubuntu server running a LAMP stack for my website. I've only had Linux anything for a few days so please bear with ...
0
votes
2answers
549 views

Working SQL client

I managed to get working Apache and everything's fine. Got MySQL running, which is nice. But then it turned out that I had to use terminal for all the SQL commands I had to put inside. I'm not close ...
0
votes
0answers
26 views

UnsupportedClassVersionError with OpenJDK 1.6 and Mysql

Using Ubuntu 13.10 on virtual server hosted by OVH (France), Server version: Apache/2.4.6 (Ubuntu), OpenJDK Runtime Environment (IcedTea6 1.13.3) OpenJDK 64-Bit Server VM (build 23.25-b01, mixed ...
2
votes
1answer
116 views

MySQL: Can only login from command line or as root

I've been trying to solve this problem for the last 3h. I've just set up a MySQL server on my dedicated root server, running Ubuntu 14.04-minimal. I have no problem logging in as root anywhere - it ...
2
votes
1answer
184 views

How can I dump and restore MySQL databases to and from Dropbox from the command line?

I have a few MySQL databases that I would like to sync between two computers. What I'd like to do is be able to have a quick command or script on one computer that I can use to quickly dump the ...
0
votes
1answer
458 views

Is syncing a MySQL database with Dropbox this easy, and is it a backup solution?

Maybe I'm wrong, but I was sure that some time ago when I was looking for a way to sync my MySQL databases using Dropbox, I was told that this was not possible because of the way MySQL works. But I ...
0
votes
1answer
147 views

Installing FOG on Ubuntu 12.04

I am trying to install FOG on 12.04 Server LTS. I have downloaded the latest version from SF, but when I try to install it, it fails when trying to install MySQL, specifically with: The following ...
0
votes
0answers
116 views

Installing sql*plus on Ubuntu 14.04

I tried installing sql*plus on Ubuntu 14.04 by following 1, 2 and 3. But after downloading Instant Client I still facing following error; sqlplus: command not found I am new to Ubuntu, guide me to ...
0
votes
1answer
35 views

Licensing terms query

This is quite non technical question, but please help me with direction. One of our customer who is enterprise (and quite nontechnical folks), is planning to buy a solution from us. This solution ...
0
votes
1answer
87 views

install phpmyadmin error

I want to install phpmyadmin on Ubuntu 14.04 LTS and type the following commands, but I get the following error message on either one of the following command. Anything I can check the configuration ...
0
votes
1answer
31 views

How to install mysql 5.1. if I already have 5.5. installed?

Currently I have mysql 5.5 installed localy. How can I install and use mysql 5.1 server? I also need to be able to go back to 5.5. at one point.
1
vote
1answer
78 views

ubuntu - upload csv file using mysql [closed]

I'm trying to upload a csv file to a mysql table and it keep giving me an error. I am in mysql using the database I want to upload the file. I've tried two queries at the command line. LOAD DATA ...
0
votes
0answers
23 views

Bind mounting for Site Storage Ubuntu and Plesk

I have Ubuntu 14.04 server installed and Plesk CP My system drive is too small to be 9f much use other than running the OS and software. So what I was thinking is I have another huge drive that id ...
0
votes
0answers
19 views

Temporarily unable to connect to database

I've got a fully patched Ubuntu 12.04 Server VM that I'm using to host a few low traffic sites. My site is PHP (WordPress) and uses mysqli to connect to a MySql database - pretty standard stuff :) ...
0
votes
0answers
80 views

Unable to configure the phpMyAdmin

I installed phpMyAdmin. It's working when I opened the link http://localhost/phpmyadmin There are no databases in the list of databases in the left pane of phpMyAdmin. When I checked below it says ...
0
votes
1answer
179 views

MySQL Workbench 6.17 error Ubuntu 12.04 x64

Im trying to run MySQL Workbench Migration to transfer a table from MS SQL to MySQL. Using the latest version of workbench (or in fact any of the latest ones), the migration fails instantly and gives ...
1
vote
2answers
42 views

Symlink are using both locations?

I've researched and didn't find any answers, so I decided to ask here. The /dev/sda2 disk of my WHM/Cpanel webserver got 100% full. The /var folder is on the /dev/sda2 disk and I've found that the ...
0
votes
1answer
56 views

Why is ubuntu server dovecot 2 coming up with Unknown setting: driver

So like I said in the quest dovecot 2 keeps coming up with "Unknown setting: driver". I've been following a guide and setup my auth-sql.conf.ext file however when I try and start up dovecot 2 I get ...
0
votes
1answer
41 views

phpmyadmin not longer working after updating ubuntu LTS12.04 to ubuntu LTS14.04

After I upgraded Ubuntu 12.04LTS to Ubuntu 14.04LTS, I found that phpmyadmin is no longer working by calling http://localhost/phpmyadmin. It did work on before upgrading. Now I get this when trying ...
0
votes
0answers
96 views

Try 'apt-get -f install' with no packages [duplicate]

I am using Ubuntu 14.04 lts OS. So when I go to installed mysql server using below command sudo apt-get install mysql-server I have some error message. This is the error message: Reading package ...
0
votes
0answers
800 views

Mysql fails to start after upgrade

I had mysql working fine, and then I upgraded from 5.1 to 5.5. Now I think it was still working after the upgrade, but I'm doubting myself now that I can't get it started again. I have looked at the ...
0
votes
1answer
222 views

Unable to execute expect script via cron even with the permissions set to 777

I created an expect script that won't seem to run when called by cron. I included the full path in cron when calling it as follows. * * * * * /usr/local/sbin/checkForRemoteTasks ...
0
votes
1answer
35 views

Decent tutorial needed for setting up simple MySQL client-server system

Could anyone please comment what I have missed during Ubuntu setup, that I am allowed to nothing on my system? Always needing to sudo from command line is not practical if you are not familiar with ...
0
votes
1answer
232 views

Cron job from mysql and send an email with results

I have a ubuntu box hosted and need to setup a cron job for executing a stored procedure and sending the results via email to one address once a week. How can I do this? I am using Mailgun
0
votes
1answer
914 views

Mysql 5.5 server not working

I had Ubuntu 14.04 installed on my system. I recently updated ubuntu and now my mysql does not start and workbench says that mysql server has been stopped. And when i try to start it gives me the ...
0
votes
2answers
229 views

Unable to upload files (pdfs, images) larger than 1 MB

I have recently started PHP and Mysql project development on Ubuntu. In one part of the project I need to upload files. But my script is not uploading anything larger than 1 MB nor does it show any ...
0
votes
1answer
36 views

How to install mysql and other software to ubuntu12.04?

I've just installed Ubuntu 12.04 to my laptop. This is the first time I'm using this OS. Their is no software to watch videos and flash player to watch in web. I'm not being able to install also. I ...
0
votes
1answer
37 views

cant remove mysql

this is terminal report of returning mysql: kajair@kajair-VGN-CS16G-R:~$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) but I can't ...
0
votes
0answers
171 views

Percona Xtradb Server Cluster 5.6 Setup

Thanks for any help you can provide I seem to be stuck on this error for hours. I am trying to setup a percona 5.6 cluster. I have installed on 14.04 these packages and removed any trace of mysql. ...
0
votes
0answers
99 views

Stuck booting after network adapter change

I have been switching around my VirtualBox network adapters recently, and when I got to the office today my Ubuntu 14.04 server VM got stuck at Starting MySQL [OK] (or whatever the phrasing is of that ...
0
votes
2answers
56 views

Have more than one mysql version installed at a time

I currently have mysql 5.5 installed, and working. I'd like to migrate everything to mysql 5.7 (for a number of reasons, but mostly the spatial functions). I would like to have both 5.5 and 5.7 be ...
0
votes
0answers
34 views

lampp MYSQL linux permissions

I decided to go safe. I am no linux expert either. I edited my.cnf and gave the mysql username (instead of nobody) I set it to 'nugget'. I then added a user named nugget and added it to the group ...
2
votes
2answers
33 views

Chown Not Responding as I expected.

New to Ubuntu, so bare with me. I recently changed the permission of mysql, /var/lib/mysql so I could save a database in it manually (was only option currently, instead of importing it the proper ...
1
vote
1answer
684 views

MySQL keeps crashing in Ubuntu 12.04

Every few hours, MySQL crashes on my Digital Ocean Ubuntu 12.04 machine. Below is the errors I am seeing in my MySQL error log. I thought it was a memory issue, so I added a swap, but that didn't fix ...
0
votes
0answers
155 views

Locked out of the MySQL database

I'm using Ubuntu 14.04 as my host for my apache-mysql-php server setup. At first, I tried installing XAMPP (from apachefriends.org) and deployed my Moodle and Wordpress sites. However, after a reboot ...
0
votes
1answer
27 views

2nd harddrive, /var/lib/mysql ownder is nvidia-persistenced when mounted, mysql when booted?

I have a second HDD that was my old OS. When I boot it the /var/lib/mysql folder is mysql:mysql but when I mount it (LVM) in my new OS it is nvidia-persistenced:vboxusers. I want to do a cp -pr to ...