Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
9 views

Problems with making a lamp database in ubuntu

I'm trying to create a lamp-server database. When I go to localhost in my browser the default apache "It's working" page is displayed. But when I'm trying to see my database with localhost/posts I get ...
1
vote
2answers
49 views

Cannot install mysql server 5.5 on ubuntu 14.04

I have tried many ways to install mysql-server. I first tried installing by executing sudo apt-get install mysql-client-5.5 mysql-server mysql-server-core-5.5 I was asked for root password, and ...
0
votes
2answers
32 views

What do these numbers mean in syslog?

I'm trying to determine why MySQL server process is being killed due to out of memory, so am looking at the sylog. Immediately before the 'out of memory' I see lots of lines with differing numbers but ...
0
votes
1answer
20 views

Can't connect to local MySQL server through socket error - Reasons of this failure?

This is my first post here. I am a newbie in Ubuntu servers :) I've a WordPress multi-site running on Ubuntu 14.04.2 LTS server, and about once per month all the sites are down due to some MySQL ...
4
votes
3answers
8k 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
23 views

mySql not working after upgrading to 15.04

After upgrading from 14.10 to 15.04 when i start rails server it gives this error: arslion@arslion-Lenovo-B570e:~$ rails s ...
-1
votes
2answers
22 views

how to reconfigure phpmyadmin?

Error: "http://localhost/phpmyadmin/index.php" Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. I was using lampp with mysql password as root ...
3
votes
2answers
3k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php ...
0
votes
1answer
16 views

E: Unable to locate package libmysql-ruby

I try to install mysql for rails but i know that first must install the package libmysql-ruby I do the command E: Unable to locate package libmysql-ruby But It returns Reading package lists... ...
0
votes
1answer
17 views

Prefix for MySQL tables in Ubuntu Home Server

So I have a question. I am a new Ubuntu Server user. I have most of it set up and now I am setting up some different software so that I can have a development environment to develop my sites. The ...
-4
votes
0answers
39 views

MYSQL installation error

I am trying to install MySQL 5.6. The installation is failing, with the output as given below. As you can see, the server starts up, and 1 second later decides to shut back down again for no ...
-4
votes
0answers
19 views

MYSQL access error using putty [on hold]

I am trying to access mysql and error like this ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) How do I access it?
3
votes
4answers
30k views

mysql server start failed

I am running ubuntu server. When I tried to login to mysql(which was running),I got the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
4k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...
0
votes
1answer
3k 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 ...
0
votes
3answers
1k views

MySQL and PHP problems

I'm new in server-side programming. I need lampp and mysql running on my computer. I have installed mysql using tasksel lamp-server, and then install php with apt-get install libapache2-mod-php5 ...
0
votes
2answers
5k views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
1
vote
1answer
154 views

Postfix and Ownclound mysql authentication

i'm using ubuntu 12.04 with roundcube/postfix and owncloud installed, and using mysql as login authentication. i would like to know if it's possible to make single login for these apps (without LDAP) ...
0
votes
1answer
9 views

Uninstall MySQL completely

The answers to related questions forget to: remove the MySQL databases remove the mysql user remove the logs in /var/log How do I uninstall MySQL completely?
0
votes
1answer
24 views

Error establishing a database connection several times a week

I have a client I do web development for who had a basic low traffic WordpRess site running on Ubuntu 12.0.4 with Digitalocean. Basic LAMP stack that they provide pre built with WordPress installed. ...
1
vote
1answer
12k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld ...
0
votes
1answer
5k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
0
votes
0answers
7 views

How can I solve problem with Jomla installation on EC-2 server?

My name is Igor, I woold like to install joomla on Amazon EC-2 Ubuntu server free tier, but I could not do this. After a week of probe and tests I deside to write you. This letter I send to Amazon and ...
1
vote
2answers
3k views

How can I load XML data into a MySQL database?

On Windows, I can use this statement to load XML data into the database: LOAD XML LOCAL INFILE 'c:/users/yourname/desktop/myfile.xml' INTO TABLE MyTable ROWS IDENTIFED BY '<product>' ...
0
votes
1answer
130 views

unoconv cannot connect or start listener without sudo

I'm working on a website for school on the school server. My website uses unoconv. It was working up until today for some reason. Basically what is happening is that if i run this command in the ...
0
votes
2answers
24 views

Redundant Web Server

I have an ubuntu 14.04 server that we use as our web server (apache). We have a public web site that is built on Drupal, uses a MySQL DB and we also have some files that are uploaded to our site and ...
0
votes
2answers
24 views

How to allow lamp and apache2 service run parallel?

I have a php project in var/www/html. It runs when I start apache2 service is started. But I cannot access phpmyadmin where I have a database that is being used in my php project. (I had to stop lampp ...
2
votes
1answer
34 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?
0
votes
1answer
37 views

Compiled mysql conflicts with already existing mysql

I have just installed mysql from source and used a paco wrapper to see the file copy locations for "make install". As per the paco log, I have the following : /usr/local/mysql/lib/libmysqlclient.a ...
0
votes
0answers
19 views

problem removing mysql

I am getting this error: E:Sub-process /usr/bin/dpkg returned an error code (1) At the end when i try uninstalling mysql using the command: sudo apt-get remove –purge mysql-server mysql-client ...
0
votes
0answers
7 views

Need to configure backup webserver

I configure ubuntu web server with apache and its run php application with mysql database. now i need to config another server. because master server down another server must be provide application. ...
12
votes
3answers
32k views

Port 3306 appears to be closed on my Ubuntu server

I have two VPS servers, and both have MySQL installed, one for testing and one for development. One of my servers won't let me connect from outside. With the user; 'mytestuser'@'%' According ...
1
vote
2answers
33 views

Xubuntu 15.04: Can no longer navigate with Ctrl + left/right on MySQL shell

In previous versions of Ubuntu (and other Linuxes), I was able to jump word-by-word in the MySQL shell with Ctrl+←/Ctrl+→. This does not seem to work in 15.04. Instead I get ;5D (Ctrl+←) and ;5C ...
0
votes
0answers
19 views

php files connected with mysql server not working

I started a php project in netbeans and connected it with a database in localhost/phpmyadmin. But on running it gives this error on browser.. Why does this happen? How to avoid it? Here are the ...
0
votes
1answer
51 views

Can't start MySQL service after permissions issues

I'm hosting a local LAMP server with Magento installed on it (in /var/www/html/magento), which I've had working fine, but I managed to break some things tonight. I encountered an issue with part of ...
19
votes
3answers
12k views

How do I install MySQL without a password prompt?

I'm trying to install MySQL on Ubuntu Natty without the password prompt. However, I keep getting prompted for a password at some stage after the main installation. Also, when I do enter what I ...
-1
votes
1answer
114 views

Problem during installing mysql server

I tried to install mysql server and mysql workbench with Ubuntu software center but It could not install them. Then I used command line to install mysql server and I run the following code repectivly: ...
1
vote
0answers
35 views

How to run php files in ubuntu?

I installed apache2, php5 and mysql. http://localhost/ url in browser shows it works. I saved a php file in /var/www/ as testphp.php. Code in the file is.. <?php phpinfo(); ?> Now on entering ...
0
votes
0answers
16 views

XAMPP: Another MySQL daemon is already running

I have installed apachi,mysql and php seperatly in ubuntu. I wanted to install xampp for run one of my project.constructorwhen I run the command sudo /opt/lampp/lampp start it display "XAMPP: ...
1
vote
2answers
6k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
-1
votes
0answers
19 views

Wordpress can't find my new database location

I made a raid5 and followed this tutorial to move mysql to the raid Moving MySQL datadir I have move the mysql database location to my raid5, but when i try to reload the wordpress page it says ...
0
votes
1answer
33 views

How to start mysqld through mysqld_safe

Specifications: MySQL Server version: 5.5.43-0ubuntu0.14.04.1 (Ubuntu) Ubuntu-Server 14.04 LTS Default MySQL-Config-File Question: Even after spending a long time I can not figure out why I can ...
0
votes
0answers
54 views

“Unable to fetch some archives” error while installing mysql on ubuntu 12.04

I am trying to install mysql on a fresh installation of ubuntu 12.04 using the command sudo apt-get install mysql-server i see the below issue with dependencies unable to download: Failed to ...
0
votes
0answers
24 views

dual monitors Ubuntu 14.04 missing characters with intel HD4400

I have an Asus laptop with Intel HD4400 graphics. When I hook up another monitor via the HDMI I lose characters. Error console in MySQL workbench is totally unreadable and same with Thunderbird email. ...
0
votes
0answers
35 views

add-relation failed between mysql and Keystone on Juju manual provisioning

When I add-relation between mysql and keystone. I've got an error 'hook failed: "shared-db-relation-changed" for mysql:shared-db' I add-relation between mysql and glance without problem,there was no ...
2
votes
3answers
9k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode. Now that ...
0
votes
1answer
4k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
1
vote
1answer
57 views

One rsync cronjob runs, but doesn't copy files

So my intention is to backup some key directory with my documents and my MySQL data file etc. I have a cronjob set and it seems to work for all commands in there. Files are copied daily into a backup ...
7
votes
2answers
8k views

MySQL Automatic backup tools

I use back-in-time for backuping up my projects. but my Database's are not included. I'd like to backup all database's scheduling by day or hours. Is there any tool to backup MySQL automatically?
1
vote
1answer
42 views

Connect java with mysql in ubuntu server

I am trying to connect my Java application with MySql running on an Ubuntu server 14.04 installed on Virtual Box in the same machine as my application. I have installed mysql-server, mysql-client and ...