Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
3answers
691 views

GUI mysql tool for multiple databases

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to ...
0
votes
1answer
508 views

Java Hibernate: Download MySql or LAMP

I am going to be writing a Spring based Java application and I was wondering if I should install MySql directly or should I just install LAMP. I would like to install LAMP, but would this have any ...
0
votes
2answers
3k views

How do I display an html file on a web browser in Ubuntu?

I am tasked with displaying a program on a web browser for my final project. The browser would be run from a cloud instance, and I have chosen to show an java applet that I have made. I have already ...
0
votes
1answer
441 views

g++ fails to link to libmysqlclient

I use Ubuntu 12.04 on a virtual machine on my MacbookPro. I installed build-essential, mysql-server and libmysqlclient-dev. Both commands 'mysql' and 'mysql_config' work. However, the following ...
0
votes
1answer
684 views

Bring in old databases in MySQL?

Ok, so when mysql updated a while back, it broke. It was simply not starting. So I tried fixing it, but hadn't been successful. I finally gave up, copied all the directories & files under /var/...
0
votes
1answer
1k views

Mysql very slow on (fast) development laptop

[Solved] Ubuntu 12.10 x64 new i7 laptop, mysql default installation. Importing a 6 MB dump file (a empty drupal dump made mostly of INSERT INTO statements) takes ~30 minutes, on other PC takes less ...
0
votes
1answer
332 views

Problem sharing Mysql data on dual boot machine

First of all let me say that this is a question following my attempt to do the solution on this post Can I share MySql database files with Windows on dual boot? . I was hit by an error and need help ...
0
votes
2answers
478 views

MySQL does not start up on ubuntu 12

MySQL Server does not start up on ubuntu 12. When I run the status command, the following message is displayed: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/...
0
votes
1answer
1k views

MySQL port forwarding

I am trying to help a colleague to connect to my MySQL server. However the situation is a bit special, and here's why (let's call him person A and me, person B): Person A has a PC, on which he has a ...
0
votes
1answer
2k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

My mysql installation was screwed up. I uninstalled and installed it multiple times. But I kept getting a hang or a error "cant connect". I now finally have it running with sudo -u mysql mysqld. How ...
0
votes
1answer
565 views

mysql does not start or work

Recently I installed LAMP with tasksel. Then I remember I issued some commands to get into the mysql console - it worked. Right now I checked - apache and php modules work perfectly. But as for mysql ...
0
votes
1answer
208 views

Which package of MySQL should I choose from the software center?

When installation MySQL in ubuntu software center There are two programs Mysql server Mysql client Whichever is chosen for the installation MySQL
0
votes
1answer
422 views

Ubuntu 12.04 MySQL 5.5 MyODBC 5.1 or 3.1 query hangs

I have been able to install Ubuntu 12.04 with LAMP MySQL version 5.5.x It works fine within linux, it allows me to connect from myodbc windows vista or windows 7 I have configured networking access ...
0
votes
2answers
4k views

Ubuntu 12.04 Mysql doesn't start on reboot; starts ok later manually

I've just installed MySql to support a mediawiki install on 12.04 64bit. Everything appears to be working ok, except that at boot-up, mysql server fails to start. This results in an error appearing on ...
0
votes
1answer
4k views

why is apt-get not install mysql server 5.5

I have mysql server 5.1 installed. I want to update it to 5.5 . I took a back up and uninstalled 5.1 using this command sudo apt-get --purge remove mysql-server* when I again used apt to install ...
0
votes
1answer
1k views

I need to install my sql server 5.1 where there is no internet connection

Please kindly help me at the following issue. Currently I don't have an Internet connection and I need to install MySQL server on Ubuntu 11.04 without any rpm packages. I have only the tar file with ...
0
votes
3answers
1k views

MySQL and PHP problems

I'm new in server-side programming. I need lampp and mysql running on my computer. I have installed mysql using tasksel lamp-server, and then install php with apt-get install libapache2-mod-php5 ...
0
votes
1answer
2k views

Unable to login using new mysql user added via phpmyadmin

On my computer yesterday I installed 12.04 and applied all updates. I have installed lamp on this system using following command sudo apt-get install lamp-server^ phpmyadmin . I created a new user ...
0
votes
2answers
4k views

innodb_buffer_pool_size not changing

I have encountered a weird problem with innodb_buffer_pool_size configuration on 5.5.23-1~dotdeb.0 (Debian): Whatever new value that I choose in my.cnf for innodb_buffer_pool_size (e.g 3G, 4G, 8000M),...
0
votes
1answer
275 views

Does mysql comes with the default installation?

I have checked that I have mysql installed. Does it comes with the default installation ? I dont remember I have installed it. Installed files : mysql server core 5.1,mysql client core, mysql common ,...
0
votes
2answers
11k views

etc/hosts setting for standalone MySql server

I am a little confused with setting up my new MySql server. It has to be a standalone server. Other webservers should connect to it. The hostname of the webserver is "webserver", the IP is 192.168.1....
0
votes
2answers
110 views

MySQL prevents server from booting unless password is entered

I am kind of new with Ubuntu but I have been working on setting up a LAMP server with hamachi as a vpn client for management. The issue is that when we turn the server on or restart it we are ...
0
votes
1answer
640 views

Alternative way to start mysql server other than upstart?

I have a chrooted 10.04 LTS installation on a NAS, it works great but breaks Upstart very badly. MySQL only works via Upstart these days, so I created a workaround to start like this: dtach -n /opt/...
0
votes
1answer
1k views

Connect to MySQL on remote server from inside python script (DB API)

Very recently I have started to write python scripts that need to connect few databases on mySQL server. The problem is that when I work from office my script works fine but running a script from my ...
0
votes
2answers
2k views

“SQL engine 'mysql' not supported” with saslauth

I'm having trouble authenticating incoming SMTP authentication to my postfix server (using Cyrus SASL with a MySQL backend). In my auth.log I get: postfix/smtpd[3389]: sql auxprop plugin using mysql ...
0
votes
1answer
1k views

Does mysqldump return a status?

I am creating a script that backups a mysql db using the mysqldump utility. I am writing this script in the shell "sh". I would like to capture the output status of mysqldump in the script (i.e. if ...
0
votes
2answers
2k views

Installing mysql causes Error 2002 error

I tried installing mysql server a couple of times and I'm having problems. First of all, when I install it gives me a message that it's setting up and it just hangs. I can't ctl + c out of it, so I ...
0
votes
3answers
573 views

I want to install and get to building a personal MySQL DB

So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file? I've only had brief experience with MSAccess and OOo Base a long time ...
0
votes
1answer
157 views

What should I do for change connection from other network computer mysql to my computer mysql?

What should I do for change my connection from other network computer mysql to my computer mysql? My computer run web application with his apache local server and mysql that located in other ...
0
votes
1answer
384 views

Which version of percona db package should I install?

I am new to both percona & Ubuntu. According to this page percona is only available for etch hardy lenny lucid maverick squeeze But i am using 11.04 (Natty). Can someone recommend me which ...
0
votes
1answer
1k views

How do I build MySQL server (5.5.8 is current latest) [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? How do i build MySql server? i was hoping for ./configure;make;make install but ...
0
votes
2answers
778 views

Apache server A attempts conn to mysql server B. times out [closed]

I have an apache web server running PHP. I am trying to make a connection from apache server to a database server running mysql server. Heres a run down of the settings in place. apache server: ...
0
votes
0answers
11 views

Ubuntu update stops while configuring mysql-server-5.7

When I update my Ubuntu sofwares and applications using Software Updater in Ubuntu 16.04 LTS, the update stops while Configuring mysql-server-5.7(when the downloaded updates are being installed). And ...
0
votes
0answers
10 views

latest xampp on ubuntu utf8 encoding issue

I have installed latest version of xampp on my ubuntu server but I have issue I use mydac to establish connection to mysql server and every thing is fine . But when I try to insert a non latin ...
0
votes
0answers
9 views

bWAPP installation ERROR

I am trying to install bWAPP on my ubuntu gnome 16.04 computer. With this tutorial. When I try out number 6 I get an error 500. My guess is that I didn't set up php correctly. But it could be ...
0
votes
1answer
25 views

How to stop XAMPP/MySQL from defaulting to IPv6?

I installed XAMPP for Linux on a fresh Ubuntu 14.04. I started all servers and ran netstat -tupln. The mysql server is running on IPv6: tcp6 0 0 :::3306 :::* LISTEN 2818/mysqld I ...
0
votes
1answer
40 views

Cannot set a different database directory for mysql ( Errcode: 13 - Permission denied) [duplicate]

I am attempting to relocate the database directory for my mysql installation to a newly install ssd. Configuration: Ubuntu 16.04 mysql Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using EditLine ...
0
votes
1answer
21 views

MySQL backup - incremental and differential

How can I backup MySQL database incrementally and differentially ? Does anyone have a script or recommended application for this purpose? Thanks.
0
votes
0answers
18 views

Error in downloading mysql server

I am downloading mysql on ubauntu software center I am getting error as follows: The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.1-...
0
votes
0answers
16 views

Starting MySQL fails after upgrading to MySQL 5.6 [duplicate]

While setting up a test server for the development of a Magento plugin, I ran into the requirement of MySQL 5.6. I was already using MySQL 5.5 so running apt-get install mysql-server-5.6 should have ...
0
votes
0answers
34 views

dpkg: error processing package mysql-server (--configure)

I am getting the following error when I remove, autoremove, install, upgrade etc.. via terminal and also software updater. The sudo apt-get autoremove result is given below. The error says dpkg error ...
0
votes
0answers
22 views

Failure to access mysql db using the Hostname of the Remote Database server

Hostname of the Remote Db server is db-20.srv.saj.co.ug and IP 192.168.2.1. Hostname of Accessing Server is Mail-20.srv.saj.co.ug and IP 192.168.2.3 Ping from Mail-20.srv.saj.co.ug to the Remote is ...
0
votes
0answers
18 views

Mysql Workbench on 14.04 with mysqlserver 5.6

I'm running ubuntu 14.04 I was running mysql server 5.5 and mysql workbench. and the world was full of joy. but one day i wanted to run mysql server 5.6 to support a new functionality. I went ahead ...
0
votes
0answers
24 views

cannot connect to MYSQL server through phpmyadmin

This is my phpmyadmin login page. I am using Ubuntu 16.04 . I am using the XAMPP server. Apache and php server are working fine ,but I cannot access the phpmyadmin. When I use sudo /opt/lampp/lampp ...
0
votes
0answers
28 views

custom mysql datadir ubuntu in 16.04

All, I noticed that in Ubuntu 16.04 if I have a custom datadir (/etc/mysql/mysql.conf.d/mysqld.cnf) the systemd service won't start because of sanity() check in /usr/share/mysql/mysql-systemd-start. ...
0
votes
0answers
19 views

Can I use one phpMyAdmin per virtualhost?

I worked on ubuntu 16.04 server, I will host multiple domains on my ubuntu server with apache virtualhost, my question is how to make phpmyadmin show only database created on my virtual host ? For ...
0
votes
0answers
45 views

libmysqlclient.so.18 => not found

This is Ubuntu 14.04 I am trying to resolve a small problem with a module not being able to see the 'libmysqlclient.so.18', if we ldd the file we see: linux-gate.so.1 => (0xf7702000) ...
0
votes
0answers
21 views

Why does MySql 6.0 show menu items twice in the menu bar?

I installed mysql 6.0 in ubuntu 14.04. When I open it, it shows me the menu items twice in the menu bar. I attached a photo of it so you can better understand. Please have a look at and help me with ...
0
votes
0answers
31 views

need help debugging server networking

I have a basic headless Ubuntu 14.04 setup with mythtv (with ethernet attached HDHR silicon dust ASTC receiver), mysql, apache, and ssh. Everything was had been running pretty well for a long time, ...