Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

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
263 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
25 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
198 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
159 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
64 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
4k 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
1answer
120 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
449 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
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
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
230 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
92 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
522 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
940 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
233 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
49 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
332 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
57 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
423 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
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
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
214 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
800 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
585 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
375 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
730 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
185 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
726 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
0answers
697 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
156 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
333 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 ...
2
votes
2answers
34 views

Chown Not Responding as I expected.

New to Ubuntu, so bare with me. I recently changed the permission of mysql, /var/lib/mysql so I could save a database in it manually (was only option currently, instead of importing it the proper ...
2
votes
2answers
526 views

Is securing phpMyAdmin with .htaccess considered sufficient?

I have just installed Linux / Ubuntu for the first time in order to learn, and to get some experience with LAMP servers. I also installed phpMyAdmin and used an .htaccess file (stored in ...
2
votes
0answers
105 views

404 not found error on apache2 [duplicate]

I have installed apache2, actual php version, mysql server and vsftp on my new Ubuntu server. I also installed wordpress and gave the user www-data all rights for /var/www/* and put it to 755. I ...
2
votes
4answers
1k views

Unable to send data to mysql database. It is not taking by my php code [closed]

I am new to PHP in Ubuntu 13.10. But I am pretty much able to handle Ubuntu. However my question is that I can't add any data to phpmyadmin through a PHP code, though my code is perfect. Because I ...
2
votes
0answers
18 views

SSL is not in use on MySQL server [duplicate]

I installed MySQL server and I want to allow SSL support. I added these lines to my.cnf [client] ssl-ca=/etc/mysql/ca-cert.pem ssl-cert=/etc/mysql/client-cert.pem ssl-key=/etc/mysql/client-key.pem ...
2
votes
1answer
328 views

what is the command to connect a database remotely from other PC

what is the command to connect a database remotely from other PC. I am running a application in a PC1(client) and storing some content of that application on a database. There is also one another ...