Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
119 views

/usr/lib/i386-linux-gnu/libmysqlclient.so.18: no version information available

I wrote a program in C++ (QtCreator) on Ubuntu 14.04 LTS which reads values from Web-API's (curl) and stores them in a MySQL Database (using the MySQL C-API). When I start the program on my Desktiop ...
0
votes
0answers
87 views

Scheduled Cron Back up from EC2 to S3

I have created a script for scheduling sql back ups and store in Amazon S3. Below is the script that I used for taking backups. DATABASES="testdb" testdb_USER=root testdb_PW=root ...
0
votes
1answer
26 views

Why is mysql run in server-client model?

From http://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run Please make sure that you have installed the mysql-server, not the ...
0
votes
1answer
157 views

MySQL Workbench doesn't start

I installed MySQL Workbench from Ubuntu software center and it just doesn't start when I click on it. There's no error shown up. What's the matter? UPDATE: $ mysql-workbench --log-level=debug3 ...
0
votes
2answers
219 views

Installing LAMP - PHP not connecting with MySQL - Why?

Am followoing this amazingly simple LAMP tutorial http://ubuntuserverguide.com/2014/06/how-to-install-lamp-in-ubuntu-server-14-04-lts.html Installing Apache Installing MySQL Installing PHP The ...
0
votes
0answers
99 views

Mysql connection error

I'm newly installed Ubuntu 14.04 on my system. And I individually installed apache2, mysql 5.6.19 and PHP Version 5.5.9-1.whenever I connect to database it's giving error in the console window like ...
1
vote
1answer
56 views

Asking for a sudo password in advance

I have some scripts for backing up data. Some of them need root access, so I use them with sudo. However, sometimes I get confused, e.g. for the mySQL backup, which also needs a mySQL root password. ...
1
vote
1answer
835 views

MySql won't start after installation on Ubuntu server 14.04.1

I'm new to Ubuntu server and MySql. I'm attempting to create a server in VirtualBox that I can use for web development and testing before deploying to a real server. I have Ubuntu server 14.04.1 ...
-1
votes
1answer
71 views

phpMyAdmin doesn't work when installing from repo

I've just installed phpMyAdmin via apt-get and rebooted. When i enter '127.0.0.1:3306' into web browser, i get something like this: I'm totally new to mysql but quite experienced with linux. How ...
0
votes
0answers
36 views

access denied from local host

Ok, I've set up my server and have been having fun designing my website. At the moment I've got several php files that access my MySQL databases. everything is ok client side and the php has no ...
0
votes
1answer
84 views

What is my phpmyadmin's url?

I'm a newbie with linux ubuntu and phpmyadmin. I had an url to access phpmyadmin thru the webbrowser, but since i did not use it for like a year now, i can't remember the url. I believe it was ...
0
votes
1answer
77 views

mysql -h slow ?? how I can correct this?

I have 3 server .1 database server(mysql as database) and 2 normal server called A and B. from A when I try to connect database using the bellow command,the connection is set within a second mysql ...
0
votes
0answers
169 views

DBI failed to connect mysql

I encountered DBI connection failure to mysql when I tried to install and configure the orthoMCL programs. I would appreciate very much if you can help diagnose and advise some troubleshooting tricks. ...
0
votes
1answer
78 views

mysqld is suddenly taking too much memory and my laptop is getting hotter

I have been using ubuntu 14.04 for a while but really new to linux command line stuffs. I mainly use it for Java/android/web development purposes. Sometimes I notice my laptop gets more hot than ...
0
votes
1answer
159 views

mysql_config_editor not included in MySQL APT Repository?

I've installed MySQL from MySQL APT Repository. Now I want to run "mysql_config_editor" to encrypt my .mylogin.cnf, but it displays: The program 'mysql_config_editor' is currently not installed. To ...
0
votes
1answer
228 views

What path shall I find schema.sql?

I am looking for file named "schema.sql", can someone let me know where can I find it? when I googled a little about it I go one path i.e. /etc/raddb/sql/mysql/schema.sql however it does not exists ...
0
votes
0answers
91 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 ...
0
votes
0answers
85 views

Does VM require Swap? su: fork: Cannot allocate memory

We have Mysql Server in AWS environment in Ubuntu 14.04. Recently our server lost new connectivity like ssh, or scp any connections due to cannot allocate memory. And my existing connectivity to ...
4
votes
2answers
2k 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
1answer
46 views

Not installing softwares after changing the server

I changed the download server from sri lanka server to US server using software and update window. Then I tried to install mysql using this command. sudo apt-get update sudo apt-get install ...
0
votes
1answer
53 views

I am not able to install mysql on ubuntu after unistalling it

I have to install MySQL in Ubuntu for a class. The first time intalling mysql it worked perfectly. However, I accidently ran the sudo mysql_secure_installation command when I wasn't supposed to. I ...
0
votes
3answers
524 views

Postfix/ Dovecot and MySQL

I have an issue in authenticating users using postfix/ dovecot with mysql at ubuntu LTS. Outlook connected to the server but got error for authentication. below is posfix configuration settings: ...
3
votes
0answers
157 views

I can't deploy mysql to LXC:0 with juju [closed]

I used "juju deploy --to lxc:0 mysql" to deploy mysql. But ,the container start failed.--"error: container failed to start" so,I used dmesg to look error message: [1318582.474759] init: ...
3
votes
0answers
609 views

MySQL Workbench do not render Columns Tab at ER

I have a fresh install of Ubuntu 14.10, after installing all I need, I started MySQL Workbench (v.6.1.7 build 1788) and in it's ER modeling its not showing anything in Columns Tab when editing a ...
0
votes
2answers
1k views

How to stop mysqld process?

result of ps -e | grep mysqld running htop and clicking on memory usage.. It is taking 33% of 4gb memory. I just want to end the mysqld process.. running sudo pkill mysqld ends the process but ...
0
votes
2answers
469 views

ERROR 1045 (28000) on mysql-server installation [duplicate]

I am new to Ubuntu trying to install MySQL. sudo apt-get install mysql-server php5-mysql then to create database directory structure sudo mysql_install_db Then to secure I use sudo ...
2
votes
1answer
48 views

Trying to sync live data to a backup server

I'd like to take the data from the live system to a backup system (to test new features etc) Piecing together an rsync command, I have the following. How do I ensure everything is copied? Things ...
0
votes
1answer
248 views

What version of “mysql-connector-java” to include in pom.xml for ubuntu 14.04

The mysql server version installed is 5.5.38 as verified by sanchit@sanchit-3560:/$ mysql --version mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.3 But in the ...
0
votes
1answer
522 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
70 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
5k 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
9k 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
508 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
525 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
67 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
206 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
242 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
4k 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
130 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
68 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
1answer
219 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
196 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
16 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
669 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
27 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
133 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
232 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
622 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
154 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
128 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 ...