Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
459 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
1answer
163 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 mysql-...
0
votes
1answer
516 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
3answers
1k 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 ...
1
vote
1answer
93 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
2answers
8k 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
248 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
1answer
9k 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 ...
1
vote
1answer
646 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 -...
1
vote
1answer
1k 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
2answers
2k 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
1k 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 ...
14
votes
2answers
10k 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
109 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 mysql-...
0
votes
1answer
65 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
1k 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
251 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: maas-...
3
votes
0answers
2k 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 table,...
3
votes
3answers
21k 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
5k 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
57 views

Entries in history

I usually include the password when I log in to MySQL. How do I exclude mysql -u root -pPassword being picked up and stored by history?
1
vote
1answer
77 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
1k 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
2k 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
181 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
27k 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 http://...
2
votes
3answers
34k 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
3k views

Error installing mysql server on Ubuntu 14.04 [duplicate]

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 verification) and ended on following ...
2
votes
0answers
1k 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 ...
-2
votes
1answer
401 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 myisam-...
14
votes
2answers
25k 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
407 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
1answer
735 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
983 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
4answers
3k 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 ...
2
votes
1answer
712 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
2k 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
2k 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
463 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
1answer
53 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
220 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 ...
1
vote
1answer
589 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
825 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
1answer
568 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
56 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
243 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
82 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
97 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 ...
2
votes
0answers
3k 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
535 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 >/...