Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
2answers
2k views

How do I install MySQL workbench?

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
2
votes
1answer
70 views

mysql and do-release-upgrade

Could someone tell me what happens to mysql databases when you run a do-release-upgrade? When I do the dry run for do-release-upgrade I see that it will uninstall mysql client and server and install ...
2
votes
1answer
132 views

MySQL upgrade stuck at version selection

I am trying to upgrade my packages on Ubuntu 14.04 , Then MySQL is asking me to choose the server's version that I want to receive , I am stuck there , can't select any option [Including none] Tried ...
2
votes
2answers
2k views

What does mysql -u root -p mean while logging in?

I am new to using Mysql and I do not understand what does -u and -p imply?
2
votes
2answers
5k views

Unable to install mysql 5.6 in ubuntu 12.04

I download mysql-5.6.16-debian6.0-x86_64.deb from official site. Install using dpkg -i mysql-5.6.16-debian6.0-x86_64.deb It does create file in /opt/mysql/server-5.6/. root@ubuntu:~# cd ...
2
votes
1answer
2k views

How to install MySQL DB 5.6.12 (downloaded from mysql.com) on Xubuntu (kubuntu-desktop) 13.04?

I have an experience of setting up and running MySQL on Windows. It is really easy. I just downloaded .zip, unpacked it in C:\MySQL, placed C:\MySQL\bin to PATH and then ran the server with the ...
2
votes
2answers
433 views

Why do the “iodbc” and “libmyodbc” packages conflict with each other? [closed]

When I install iodbc the libmyodbc package is removed, and I don't understand why. Does anyone have an explanation?
2
votes
2answers
146 views

mysql ubuntu noinstall

I am looking for MySQL "no-install" version for Ubuntu. I can successfully run MySQL on Windows (using MSI Installer as well as no-install). With Ubuntu, MySQL got installed using the software center. ...
2
votes
2answers
82 views

Need database selection advise

I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design ...
2
votes
1answer
4k views

Take text from a file and insert to a mysql table using a script

I would like to take data (some text) from a file and insert it into a mysql field, using a script. I have tried: mysql -u root -p password dbname << INSERT INTO tblename (fieldname) VALUES ...
2
votes
3answers
14k views

mysql problem '/var/run/mysqld/mysqld.sock'

I got this error on my php script with db: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and on phpmyadmin: #2002 Cannot log in to the MySQL server What is ...
2
votes
1answer
270 views

Ubuntu generated new mysql configs

I deleted /etc/mysql, everything in it. I tried: apt-get --purge remove mysql-server Then: apt-get install mysql-server They will not return, how do I get them to? There seems to be some very ...
2
votes
2answers
77 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 ...
2
votes
1answer
124 views

How can I set a symlink from /tmp/mysql.sock?

I've tried to set a symlink from /tmp/mysql.sock -> /var/run/mysqld/mysqld.sock however whenever I try to do it using the following command: sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock ...
2
votes
1answer
335 views

How to update MySQL Server, MySQL Client and phpMyAdmin to the latest stable versions on my local machine running on 64-bit Ubuntu 12.04 LTS?

I'm using 64-bit Ubuntu 12.04 LTS on my machine. I've already installed LAMP server on my machine. I'm using following Apache HTTP Server version. I got following information after I type following ...
2
votes
1answer
36 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?
2
votes
1answer
234 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
77 views

A question on mysql command

I want to config postfix. I followed these instructions. On the first step I saw this mysql command: mysql > GRANT SELECT ON servermail.* TO 'usermail'@'127.0.0.1' IDENTIFIED BY 'mailpassword'; ...
2
votes
1answer
2k 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 ...
2
votes
2answers
5k views

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

I am getting this error while importing the database in mysql, and when I resubmit the same file than I am getting this error Error SQL query: -- -- Dumping data for table `adminnotification_inbox` ...
2
votes
1answer
178 views

sendmail & MySQL

I had MySQL and PHP working good in the nginx server. For mailing purpose I installed sendmail. Now all I get is Your PHP installation appears to be missing the MySQL extension which is required by ...
2
votes
2answers
4k views

Updating variables in my.cnf

I set lower_case_table_names = 2 in /etc/my.cnf file. I also updated this variable in /etc/mysql/my.cnf file. After setting the variable I restarted mysql server, but still the value is 0, when I use ...
2
votes
1answer
479 views

Juju deploy of Charm (Mysql) in MAAS provider failing after successful bootstrap. Juju status stuck in “Pending” state

I have setup a MAAS environment and using Juju to deploy services. I followed the simple juju tutorial of trying to deploy Mysql and Wordpress. The bootstrap node has come up fine without any errors. ...
2
votes
2answers
3k views

Mysql broken packages

I am not able to fix broken packages to my ubuntu machine. I followed many command posted on forums. Nothing happened! The packages that have the problem are: mysql-server-5.5 mysql-server Any way ...
2
votes
1answer
7k views

how to run php web application in lamp server and mysql connection also

i need your help. 1.i wanted to install php , mysql and server appache like.. 2.how to run php web application in server? 3.how to connect php web application into mysql.
2
votes
2answers
2k views

How I can set-up MySQL on Lubuntu for education purpose?

I have Lubuntu 12.10 x86 on my notebook with all updates. I downloaded and install MySQL Community Server and MySQL Workbench. I learning Java and our next lesson will be about MySQL. I need to ...
2
votes
3answers
8k views

How do I import an mdf database file into MySQL?

I have an .mdf file(which is supposed to have database). I'm using Ubuntu 12.10 . I want to import the database into mysql.5.5.28-0ubuntu0.12.10.2 (Ubuntu) as this is version I'm using for mysql.
2
votes
1answer
264 views

Is it safe to Install Both Redis and MySQL on the same system?

Mine is a question not on how to install either but on whether I can have both MySQL and Redis-Server on my Ubuntu 12.04 machine. I need both for different projects, any help forthcoming will be ...
2
votes
2answers
6k views

phpmyadmin 404 error on fresh ubuntu 12.04 install

I regularly set up Virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed: 1)VB guest additions no longer allow ...
2
votes
1answer
98 views

How do I turn on a login page for Bugzilla?

I have Bugzilla 4.2.1 running on my Ubuntu 11.10, It working as it should and everything is fine. Now when somebody accesses the URL www.myapplication.com/bugs without logging in, it allows the user ...
2
votes
1answer
528 views

Where is mysqld.sock?

I am missing mysqld.sock in Ubuntu Server 12.04. Neither locate nor even apt-file search mysqld.sock (ran apt-file update before) can find it. Where is it?
2
votes
2answers
7k views

How to install mysql 5.1 on 12.04?

I just installed Ubuntu 12.04 at work, which runs very well. Unfortunately, for work reasons, I need to use mysql version 5.1. I can't find a clean way of installing it. I must install it the usual ...
2
votes
1answer
2k views

Why isn't the MySQL extension loading?

Please help! I've been going at it for a while and I can't get it to install, keep getting the ol message below. Running on my own server. MYSql, PHP, Apache instaled. Already uncommented the ...
2
votes
1answer
5k views

mysql service do not launch

Sorry for my English; I was trying to create db with rake in RoR application that has been configured for MySQL(gem installed, settings changed). After that attempt mysql-server broke: d@calister:~$ ...
2
votes
1answer
996 views

How to debug a server that crashes once in a few days?

One of my servers crashes once in a few days. It does low traffic static web serving + low trafic dynamic web serving (PHP, local MYSQL with small data, APC, MEMCACHE) + some background jobs like XML ...
2
votes
1answer
3k views

Problem running multiple MySQL instances

I'm trying to run multiple instance of mysql 5.1.49 on ubuntu 10.10 to setup a replication/backup database. I have added following line to /etc/mysql/my.cnf: [mysqld2] server-id = 2 socket = ...
2
votes
1answer
24 views

What is a (reasonably) secure and automated way to backup my mysql database using (any) free cloud/online services?

I have a mysql database that I use for personal devlopment. I would like to back-it up online using any free (in cost) online storage. (dropbox, google-drive etc...) I am assuming a shell script ...
2
votes
1answer
93 views

Error while installing phpmyadmin package in ubuntu 14.04 [closed]

root@anonymous-20-a213l:~# apt-get -y install phpmyadmin Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may ...
2
votes
1answer
1k views

Mail Server Can't Receive Email But Can Send Email - Postfix, Dovecot, MySQL

I have server where I want to set up a mail server to let me receive and send email from my domain. I'm currently having a problem where while I am authorized to send email from the server, but ...
2
votes
1answer
56 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 ...
2
votes
2answers
711 views

Auth succeeded No requires line available

Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess; Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely: <Directory ...
2
votes
1answer
468 views

MySQL import never completing

I wrote a bash script, and here is my problem. The script run for hours, and it never completes. I see the MySQL import process finish, but the script never gets any further. I have tried adding an ...
2
votes
1answer
59 views

Start services only when really required

I use my desktop box as dev "server", so I have installed mysql+apache+whatever. This causes boot to last longer, also memory consumption is high since I have all this services running. Does a ...
2
votes
1answer
511 views

How do I set up a Tor server?

I would like to host a tor hidden services website (aka .onion site) on my Ubuntu desktop with the LAMP stack installed. While the tor docs offer some guidance on running an anonymous server, the ...
2
votes
1answer
2k views

Can't connect to mySQL server which is running

I installed the latest mySQL Ubuntu distribution on my Ubuntu 13.04. The installation of the localhost server was succesfull and was working fine for a while. After creating a couple models (with no ...
2
votes
1answer
249 views

upgrade MySQL through apt not effect?

I am upgrading mysql-server and mysql-client my 12.04 using apt-get. seems the upgrade didn't take effect? Any thoughts why this happen? I did reboot after upgrade. Thanks. $ mysql -V mysql Ver ...
2
votes
1answer
880 views

How to fix AppArmor `could not open` error when installing php+mysql?

I want to install php5-imap php5-ldap php5-curl sudo apt-get install php5-imap php5-ldap php5-curl I get this error: AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in ...
2
votes
1answer
617 views

MySQL Replication

I have 2 MySQL servers, Master & Slave , running on Ubuntu 12.04. I have replication working from the Master to the Slave. If the Master goes down and the Slave is used, how do I get data to ...
2
votes
3answers
396 views

How to disable mysqld in 10.04?

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them -- $ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07 $ ps -ef | grep -i ...