Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
2answers
1k 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
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
278 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 ...
2
votes
0answers
116 views

Ubuntu virtual memory overcommit apparently hitting MySql performance

I have several installations using Ubuntu Server 10.04 and 12.04 LTS running on Dedicated and VPS with various hosting companies. I am hitting a problem where, especially on migrating to a new server ...
2
votes
1answer
570 views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
2
votes
2answers
6k views

'Unable to set password for the MySQL “root” user' on a Openvz VPS

I'm trying to install mysql server on my Openvz based VPS running Ubuntu 13.04 64bit and i keep getting this error at the install. I tried multiple times and i also re installed the os with no change ...
2
votes
1answer
3k views

“Can't create test file /var/lib/mysql/user-desktop.lower-test”: How to run mysql server on Xubuntu 13.04 (kubuntu-desktop)

I have downloaded and unpacked MySQL 5.6.12 to /opt/mysql/server-5.6. I want to use this db instead of pre-installed 5.5 version. But neither version works. When I want to start a server with mysqld ...
2
votes
3answers
111 views

Using existing mysql database in lampp

I'm using ubuntu 13.04 in a 32 bit machine. I have Windows 8 installed also. I have set up lampp in my ubuntu OS. Now I want to use mysql databases of Windows in ubuntus lampp. I have searched a lot ...
2
votes
0answers
87 views

Using multiple cheap server to scale my website needs, which technology? [closed]

I have developed a website that is running on MySql/Php/Apache and it is performing quite well. But with more users uploading their stuff the space available on my server is reducing and eventually I ...
2
votes
4answers
5k views

Can't install MariaDB 5.5 or 10 in Ubuntu 12.04. MYSQLD Failed to start?

I tried o install MariaDB on my Ubuntu 12.04 server. First it gave dependency issues and I fixed it by following this question : ...
2
votes
4answers
1k views

Why I can't open mysql 5.6.10 from terminal on Ubuntu 12.10?

I've always used Ubuntu to host my servers and I wanted to try the new MySQL version. So I downloaded MySQL 5.6.10 (.deb) from their official site and installed it like this: Tutorial for MySQL ...
2
votes
0answers
501 views

How I can connect the syslog-ng with a mysql database?

Hi guys I want to use a syslog-ng server for logging data from the firewall and I get Data from the Firewall in the file /var/firewall.log but now I want that the logs go to a database. For this I ...
2
votes
1answer
2k views

How can I install specific version of MYSQL

I'm trying to install mysql-server 5.0. because I want to install a program which depend on this version. I've surfed the net to find a solution but none of them worked. I'm really disappointed. I ...
2
votes
1answer
3k views

mysql not starting

I have a server running on rackspace.com, it been running for about a year (collecting data for a project) and no problems. Now it seems mysql froze (could not connect either through ssh command line, ...
2
votes
0answers
228 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table ...
2
votes
1answer
1k views

MyODBC with MySql in Ubuntu 11.04

I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines: sudo apt-get install iodbc sudo apt-get install libmyodbc I start the ...
2
votes
0answers
427 views

How to setup LAMP environment? [duplicate]

Possible Duplicate: What's the easiest way to set up a LAMP stack? I have been using XAMP in windows for a long time. Recently I have moved to Ubuntu and now want to have a similar ...
1
vote
4answers
16k views

How to upgrade mysql 5.5 to Mysql 5.6 on 12.04? [duplicate]

I need to install Mysql-server-5.6 in my ubuntu development server 12.04. Now it is running percona-server5.5. How can i upgrade this to mysql-5.6 ?
1
vote
5answers
8k views

Upstart can't start MySQL

After an installation of MySQL, I get a few errors and I can't run the MySQL daemon. I've tried uninstalling and reinstalling several times, and I'm not sure what's going on. Here's a snippit of what ...
1
vote
1answer
296 views

Installing apache , php and mysql on ubuntu 8

I want to install php, mysql and apache on my ubuntu , I tried all tasks but I can not do it. there is no package php, apache or mysql please help me
1
vote
3answers
942 views

no mysql workbench in ubuntu 12.04 software center

I have already installed MySQL workbench from the Software Center on a recent installation of Ubuntu 12.10 (32 bit) with no problems. Since then, I just installed ubuntu 12.04 LTS on another machine ...
1
vote
3answers
2k views

How do I setup php+My sql development environment

How do I setup php + My sql development environment in Ubuntu ?
1
vote
2answers
3k views

MySQL starting error

I installed LAMP not so long ago and it worked fine but ever time I try start MYSQL server I see this thing: $ /etc/init.d/mysql start Rather than invoking init scripts through /etc/init.d, use the ...
1
vote
1answer
81 views

Linux-Ubuntu Problem : Cannot find mysql database after connection is made to mysql

I have a war file deployed in webapps folder at /srv/apache-tomcat-7.0.53/webapps/ War name is InIndia.war I have deployed inindiadb.properties in classpath which is /srv/apache-tomcat-7.0.53/lib ...
1
vote
3answers
4k views

Debconf errors when configuring mysql-server

When I try to run sudo apt-get upgrade I get the error below. I also get similar error when running sudo reconfigure postfix, which I relly need to run since outgoing e-mail is not working any more. ...
1
vote
5answers
2k views

How to install Ruby on Rails and MySql?

How to install Ruby on Rails and MySql on my Ubuntu 10.04 OS?
1
vote
1answer
1k views

How to install mysql DB while offline?

I have downloaded mysql-5.5.9-linux2.6-i686.tar.gz file. I don't know how to install it into my Ubuntu os. I don't have an internet connection, I'm posting here from browsing center. I can download ...
1
vote
2answers
2k views

Shell script issue: cron job script to Restart MySQL server when it stops accidentally

I have this script, I am using it to setup CRON job to execute this script, so it can check if MySQL service is running; if not then it restart the MySQL service: #!/bin/bash service mysql status| ...
1
vote
2answers
115 views

Unable to locate package libmysql++-dev

root@avidgamers:~/warcraft/aG-HostbotRU/ghost# apt-get install libmysql++-dev Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
1
vote
2answers
2k views

What Are Steps To Install MySQL?

To my downloads directory, I have unpacked the MySQL-server-5.6.11-2.linux_glibc2.5.i386.rpm. There is now a /usr directory with /bin, /lib, /sbin, and /share within the /usr. There is also a /etc ...
1
vote
3answers
3k views

How to remove MySQL completely with config and library files?

I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... ...
1
vote
2answers
3k views

jdbc 4.0 in Ubuntu 12.04

I'm developing an application using Java and MySQL. I've installed libmysql-java package as a database connector, but the installed connector implements version 3.0 of the JDBC specification. Does ...
1
vote
1answer
3k views

Is multiple mysqld processes for 1 mysql server is normal?

I'm not an server administrator, but i would like to know why on the server i have like 10 myslq instances? Is it good or bad? Does it negatively impact speed of my website? Here's screenshot: ...
1
vote
2answers
60 views

How do I check services requiring a restart (of services, not the machine) by installing updates to other packages

If I run sudo apt-get upgrade then I get shown a list of packages and if any of these are services, they may need to be restarted (which is done automatically when installing the updates). How can I ...
1
vote
1answer
65 views

Shutting down ALL services (server backup)

I am running Ubuntu server 12.04 LTS. After many trials and errors, the backup strategy I have selected resorts to using TAR (mostly because I was unable to find a tool to backup/restore dovecot ...
1
vote
3answers
74 views

Migrate whole mysql to another server [closed]

I'm switching from a vps to another one and i need to migrate my mysql server. Is there an easy way to backup/restore ALL databases and users (with permissions) at once? Many thanks
1
vote
2answers
360 views

Are Apache, PHP and MySQL installed by default?

Are the Apache server, PHP, and MySQL installed by default when you install Ubuntu 13.10, or should you install them separately later? Original question: Quiero saber si en la instalación de ...
1
vote
1answer
657 views

Script to enter data from mysql database into text file

I have written a script to extract the contents of a table into a textfile. this is my code #!/bin/bash mysql -uroot -ppasswd database select * from table>textfile.txt i have changed ...
1
vote
3answers
2k views

Any apt command not found [closed]

I'm trying to install various packages, such as mySQL, but whenever I try to do "sudo apt-get install mySQL" it says that the command cannot be found. I only have access to the box via SSH, so any ...
1
vote
1answer
2k views

How to install the mysql connector for C#?

I installed Wine and now I have setup Mono & .NET When I try to compile the next sentence, I get an error because I don't have the MySQL connector installed on my system. using ...
1
vote
1answer
1k views

Apache / MySql is not running. What is wrong?

I installed lampp / xampp on my Ubuntu 12.04. After installing, Apache and MySQL were running properly. Now, they're not. Here's what I get when I try to run apache: Command: /etc/init.d/apache2 ...
1
vote
1answer
5k views

Installing MySQL Connector/C++

I would like to know which is the procedure to install the mysql c++ connector. After installing it to my Ubuntu OS will I have these extra c++ commands avaiable in every c++ IDE? For example, can I ...
1
vote
2answers
358 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?
1
vote
4answers
2k views

How to get MySQL back on Ubuntu 12.04?

The upgrade to Ubuntu 12.04 delete MySQL and I need urgently to get it back. The problem is that I'm getting an error installing it, either with apt-get or aptitude: Errors were encountered while ...
1
vote
4answers
2k views

Mysqld not starting on boot?

After upgrading to Pangolin, mysqld is not starting on boot. I've looked into various other MySQL issues with the Pangolin release, and I haven't seen the same issue that other people are having ...
1
vote
2answers
8k 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 ...
1
vote
1answer
1k views

Can't get MySQL workbench to work

I've installed Ubuntu 11.10 and can't seem to get MySQL workbench to work. I have tried installing both versions from the website by downloading the .deb files for ubuntu 10.04 and 11.04, but both ...
1
vote
2answers
5k views

Installing old MySQL server 4.1 on Ubuntu 11.04

how do I need to install mySQL server 4.1 on Ubuntu 11.04 server for a legacy app to run (it breaks on mySQL 5). sudo apt-get mysql-server-4.1 doesn't work - "package is missing, obsoleted or ...
1
vote
2answers
514 views

Backing up MySQL Database (Up to a month or while theres space)

I am backing up my files using deja-dup. But how do I do the same with MySQL? I see some cron scripts, but that will keep backups forever. I thought the feature of deja-dup that allows backups to be ...
1
vote
1answer
269 views

How do I configure Ruby on Rails to Always use mySQL as the default database?

How do i configure Ruby on Rails to always use mySQL as the default database? I am a newbie and i just installed Ruby on Rails and mySQL and by default ROR uses sqlite3, but when I configure the db ...