Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
3answers
6k views

mysql error 1045(280000) access denied for user 'debian-sys-maint '@' localhost using password 'yes'

I edited deian.cnf to change the password of mysql (ubuntu server) sudo vi /etc/mysql/debian.cnf I change user=debian-sys-maint password=* to user=debian-sys-maint ...
0
votes
1answer
451 views

How do I set up PHP and MySQL cronjobs on Ubuntu 12.04 (Precise Pangolin) server?

I just made a LAMP install and got SFTP working. My question now is: How do I set up cronjobs on Ubuntu server? I need to make some cronjobs for my PHP/MySQL application. I look for un-activated ...
0
votes
2answers
1k views

How to install the latest versions of LAMP componanents [duplicate]

I want to develop web applications with PHP, for that reason I need to install a LAMP system, I heard that it's good idea to use latest versions of PHP, MySQL and Apache ... so if it's possible please ...
1
vote
2answers
6k views

What alternatives to MS Access exist for database management on the Ubuntu platform (LibreOffice Base isn't cutting it) [duplicate]

I have a web-based MySQL database, which is very important. I have used the MySQL Connector to allow me to use an MS Access database to query, and clean up my database, through an ODBC connection. ...
0
votes
2answers
210 views

I am trying to check the mysql bind address int the terminal but keep getting error can someone help?

I am trying to check the mysql bind address in the terminal using the command cat/etc/hosts | grep localhosts that I got offline, but I keep getting a bash: cat/etc/hosts: no such file or directory ...
0
votes
2answers
440 views

Will I lose mysql installation and associated databases if I reinstall Ubuntu?

I just ran into an OS issue, and I was thinking of simply doing a reinstall of Ubuntu. I was looking at the Ubuntu installation options, and I saw that I could "Reinstall Ubuntu 13.04". "Documents, ...
0
votes
1answer
7k views

How to let MySQL (mysqld) to create and write to “/var/run/mysqld” directory?

I really don't understand how all those privileges work in Linuxes. To start MySQL server mysqld program has to write its .pid files to /var/run/mysqld/ directory. But we know from FHS (Filesystem ...
3
votes
1answer
14k 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 ...
1
vote
0answers
91 views

Mount Drive at Start-up but MySQL can't see it

I'm trying to automount my drive using the following command in startup applications: /usr/bin/udisks --mount /dev/sdd1 However, MySQL fails to start when I mount the disk. On the contrary, if I ...
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 ...
0
votes
1answer
118 views

Speed up reading/writing partition

My MySQL program is on /. If I move my databases to a partition (a separate hard-disk drive) mounted on /tee, then reads and writes (MySQL queries) take an exceedingly long time: many times more than ...
0
votes
1answer
459 views

After removing a folder (apache2 I think) I'm having PHP and LAMP trouble

When I go to phpmyadmin it says: The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" ...
2
votes
3answers
144 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 ...
0
votes
2answers
5k views

PHP Fatal error: Call to undefined function mysql_connect() [duplicate]

I'm trying to connect my PHP page to MySQL database, but I'm getting this error : PHP Fatal error: Call to undefined function mysql_connect() I'm working on Ubuntu 11.10 MySQL 5.5 and PHP 5.3. I ...
0
votes
1answer
6k views

Xampp : http://localhost/xampp/splash.php :english : nothing happens

After I start Xampp on my Ubuntu 12.04 I go to the localhost and I come to the site, where all languages are listed .... when I click any of these languages nothing happens. Follow steps are already ...
-1
votes
2answers
106 views

Should I use desktop or server version for my own java+mysql trading system? [duplicate]

I am going to build a trading system with java and mysql but I am not sure should I use desktop or server version. The backtest part would involve a lot of calculation and live trade part requests ...
2
votes
0answers
105 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 ...
3
votes
1answer
902 views

wordpress mysql physical files .MYD not in /var/lib/mysql/dbname

I installed wordpress on my home server (multisite install + varnish cache). Now I'm looking into /var/lib/mysql/dbname to recover the mysql files, and here is what I find : All the important tables ...
0
votes
2answers
910 views

Mysql server installed but not running

I tried to install mysql 5.6.12 using the following procedure # Preconfiguration setup shell> groupadd mysql shell> useradd -r -g mysql mysql # Beginning of source-build specific instructions ...
0
votes
1answer
4k views

Mysql 5.6.12 Installation from source code

I downloaded the Mysql-5.6.12 source code from the official website and extracted its contents in /usr/lib but the problem Im facing is now how do I install it? I followed the steps to install it it ...
1
vote
2answers
5k views

Connect to MySQL DB tunneling with SSH using Emma

I have tried using the mysql-workbench but it was too confusing, then I decided to use emma instead. I am trying to connect to my MySQL DB through SSH, but I don't see that option when I try to make a ...
1
vote
2answers
4k views

install mysql connector

I am attempting to copy mysql.jar.com.mysql.jdbc.Driver in the Java directory. I get a permissions error. I have administrative privileges so I don't know what the problem is. My feeling is that ...
12
votes
4answers
10k views

Install Apache, Php, Mysql latest versions not available via apt

I need to install the latest versions of apache, php and mysql that are available on their websites, but the problem is that apt repositories don't have these updates versions yet. Versions that I ...
1
vote
1answer
3k views

How to remotely backup a MySQL database?

How to backup MySQL database in a remote location using rsync? I tried mysqldump but it is storing the backup in the local machine only. Also I need the backup files to be stored in tar format in the ...
0
votes
2answers
8k views

php-server setup not working

I have installed php and apache2 server before but I'm getting bogged down with errors. The process so far is as follows: sudo apt-get install tasknet sudo apt-get install lamp-server During the ...
0
votes
1answer
2k views

mysql server backup using copying database files

I want to backup mysql databases to another new server. I don't want to use mysql replication and mysqldump for backup as they are using higher cpu and higher i/o on server. I tried mysqlhotcopy to ...
5
votes
3answers
25k views

phpmyadmin throws a 404 on opening

I have installed php5 and phpMyAdmin from the Ubuntu Software Centre on a fresh install of Ubuntu 13.04. when I enter localhost in my browser the following is displayed: It works! This is the ...
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 ...
0
votes
0answers
27 views

Unable to install MYSQL Natty-security issue [duplicate]

I am running a Ubuntu 11.04 on my system. Trying to uninstall mysql server from the terminal: sudo apt-get install mysql-server But it fails with the following set of errors: Reading package ...
0
votes
1answer
351 views

uninstalling mysql from ubuntu

I installed mysql in my system using ubuntu12.10 by tar.gz file. Now,I wanted to remove it from the system,please suggest me the ways to uninstall it. Thanks in advance
3
votes
1answer
10k views

apt-get upgrade - packages have been kept back: mysql [duplicate]

On my ubuntu vps, I've this error, What does it mean? Why were packages kept back? I was advised not to do dist-upgrade. My question is not how to solve this, but why this happened? The following ...
1
vote
2answers
156 views

Have I over-installed MySQL?

I ran the following from the terminal: sudo apt-get install mysql-server mysql-client I then checked to see if MySQL was running: sudo netstat -tap | grep mysql I saw something similar to ...
0
votes
1answer
207 views

Trouble starting mysqld on mysql cluster

I set a cluster using mysql-cluster-gpl-7.2.12, first it was working fine but suddenly started to fail. I can start the nodes (ndbd) but when I try to start mysqld (API), it shows an error it says ...
0
votes
3answers
620 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 ...
1
vote
2answers
3k 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 ...
0
votes
1answer
2k views

How to Automatically synchronize phpmyadmin on two lampservers?

My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed. I have synced the two lamp servers /var/www folders with ...
1
vote
3answers
2k views

upgrade percona-server package fails

This has been happening for a few weeks. Every other package upgrades without issue except this one, but I'm not sure what's causing this or how to debug it. sudo apt-get upgrade Reading package ...
3
votes
0answers
565 views

Using gnome-keyring with svn via ssh and mysql-workbench

Problem: mysql-workbench fails to connect to the keyring to connect to mysql. I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
4
votes
3answers
10k views

Recommended testing tools to test MySQL performance?

What is the recommended tool(s) for testing the performance of MySQL 5.5 (innodb) under Ubuntu 12.04? We have purchased a new multi-cpu multi-core server to replace our current MySQL dual-core ...
0
votes
1answer
465 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 ...
-1
votes
1answer
693 views

myloader Segmentation fault (core dumped) [closed]

myloader --directory=$DB_DUMP --queries-per-transaction=50000 \ --threads=$THREADS --compress-protocol --verbose=3 \ --socket=$MYSQL_SOCK --user=$MYSQL_USER --password=$MYSQL_PASS # ...
2
votes
6answers
17k 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
908 views

Mysql5.6 and problem of php5-mysql , mysql-common packages

I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 ...
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 ...
0
votes
2answers
2k 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
3k views

Mysql Datadir on different hard drive

I'm currently running Ubuntu 13.04 and MySQL 5.5. I have been using InnoDB, and the default location for installation. The problem is that my main OS partition is fairly small (36GB), and I need to ...
0
votes
1answer
879 views

What won't MySQL start?

MySQL will not start, and I need some help to figure out why. $ download mysql-common [sudo] password for zero: Reading package lists... Done Building dependency tree Reading state ...
8
votes
1answer
21k views

Upgrade MySQL server issue [duplicate]

I failed to upgrade MySQL server. Here's what I tried: I first issue this command to update the package list: sudo apt-get update Then, upgrade by: sudo apt-get upgrade It shows the following ...
3
votes
3answers
4k views

Cannot get mysql to work/start even after clean install

I am completely stumped right now, whilst I am not an advanced user, I know my way around Ubuntu and so tried to look into things with the help of certain forum topics. The Problem: Today, quite ...
0
votes
1answer
376 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 ...