Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
2answers
142 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
3k 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
1answer
266 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
1answer
45 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
238 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
180 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
71 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
5k views

unable to create database due access denied

I just logged in to Ubuntu 12.04 as a normal user (vivek) and opened the terminal to create a database, I wrote: create database Hello; and the error I had is: ERROR 1044 (42000): Access denied ...
2
votes
1answer
1k 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
3k 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
139 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
3k 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
463 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
2k 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
2answers
1k 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
6k 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
240 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
5k 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
93 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
524 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
6k 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
956 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
2k 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
119 views

Systemd Mysql won't stop

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just ...
2
votes
1answer
228 views

Upgrading MySQL 5.5 to MySQL 5.6 on Ubuntu 14.04 LTS

I have installed my LAMP with the following commands: sudo apt-get update sudo apt-get install apache2 apache2-suexec mysql-server php5-mysql sudo mysql_secure_installation sudo apt-get install php5 ...
2
votes
2answers
54 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
426 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
51 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
1answer
371 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
58 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
453 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
1k 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
225 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
817 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
597 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
379 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 ...
2
votes
1answer
754 views

Package error while trying to upgrade mysql-server

I am trying to upgrate mysql 5.1 to version 5.5 Since official ubuntu repositories do not provide 5.5, I've decided to go with Dotdeb repository. When I've updated the package information and typed ...
2
votes
2answers
2k views

Why can't I telnet to MySQL?

When trying to connect to mysql server via telnet I am getting following error: telnet localhost 3306 Trying ::1... Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection timed out ...
2
votes
1answer
186 views

Is there a solid howto for replacing MySQL with Maria in the LAMP stack?

I've heard great feedback on a few folks migrating production machines (including from this question), and I'd like to test the transition in our dev environment. Maria is apparently in the 11.10 ...
2
votes
1answer
6k views

Installing MySQL 5.1

this question is surely a dupe of http://stackoverflow.com/questions/1632056/how-do-you-install-mysql-5-1-on-ubuntu-8-10 Since I can't comment on that one...I am starting a new one. I'm having the ...
2
votes
2answers
731 views

Using Upstart after building Apache & Mysql from source

I'm using Ubuntu 10.10, Apache 2.2.17 and Mysql 5.5.10. I need some assistance getting Apache and Mysql running on boot. Reading the getting started over at upstart website attempting to get it to ...
2
votes
1answer
1k views

Why is mysql unable to configure?

I try to install mysql-server on my Ubuntu vps server, and it's able to install, but not to configure. If it tries to configure I get this: > ...fail! invoke-rc.d: initscript mysql, action ...
2
votes
1answer
79 views

Error Updating MYSQL package

My computer froze and I forgot it was updating in the background so I restarted it. When I rebooted I tried to login (and if I entered the wrong password it said incorrect password), but then the ...
2
votes
0answers
817 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
173 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
436 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 ...