Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
2answers
15 views

Need to install specific version of LAMP prerequisites on Ubuntu 14.04 desktop LTS

I need to install below specific version on Ubuntu Linux (desktop 64-bit 14.04 LTS) how can I do that please help PHP 5.3.28 Mysql 5.5.38 Apache 2.2.26 Any help will be highly appreciable Regards ...
1
vote
0answers
9 views

What is a (reasonably) secure and automated way to backup my mysql database using (any) free cloud/online services?

I have a mysql database that I use for personal devlopment. I would like to back-it up online using any free (in cost) online storage. (dropbox, google-drive etc...) I am assuming a shell script ...
0
votes
0answers
12 views

phpmyadmin problem using apache2

test.php work good but when i connect to ( localhost/phpmyadmin ) i have this <?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * * @package PhpMyAdmin */ /** * Gets some core libraries ...
0
votes
0answers
4 views

MySql Workbench on Ubuntu 14.04 Create Table editor not working

My system: Dell Inspiron 5000 laptop Ubuntu 14.04 LTS 64 bit OS I installed MySql Workbench 6.0. If I attempt to create a new table using the GUI, the table editor opens and suggests a first column. ...
0
votes
4answers
22 views

I installed mysql sever. but it doesnt work.?

ERROR 1045 (28000): Access denied for user 'vindhya'@'localhost' (using password: NO) this is the error massage I got... i don.t know how to log mysql
0
votes
1answer
17 views

MySQL Crontab Check

I have a serverpilot.io server running from digitalocean (1gb Ram), MySQL will crash once a week, the stats say the server is using ~256 mb out of 1 gb, but mysql will crash saying out of memory.... ...
0
votes
0answers
14 views

Does someone knows how to fix this installation bug in ubuntu?mysql-server-5.6 E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm trying to remove mysql-workbench. But everytime when I try to remove something related with mysql, I get this error. Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
33 views

Backup of MySQL database manuelly

in the datadir of mysql are the folders named like the database. If I want to install this database on an other server manuelly, could I copy this folder on a e.g. USB stick and put it on the datadir ...
0
votes
1answer
28 views

Having trouble in installing and removing mysql in ubuntu

I have trouble in installing or removing the partly installed mysql-server-5.6 in ubuntu15.04. The error I am getting was sudo apt-get -f install Reading package lists... Done Building dependency ...
0
votes
0answers
9 views

Loadbalancing mysql with haproxy

How to load balance a mysql server with master-slave architecture with HAproxy?If not ha proxy,is there any other way?
0
votes
1answer
15 views

How to create folder in mysql5.7?

I try to upload video php to mysql. i try to create folder but not success. below step i apply Edited phpmyadmin's config file nano /etc/phpmyadmin/config.inc.php Added the path for both upload and ...
0
votes
0answers
12 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
42 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
23 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 ...
1
vote
2answers
74 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 ...
-1
votes
2answers
25 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 ...
0
votes
1answer
27 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 ...
0
votes
1answer
24 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... ...
-4
votes
0answers
44 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
21 views

MYSQL access error using putty [closed]

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?
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
0answers
9 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 ...
0
votes
1answer
29 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. ...
0
votes
2answers
25 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
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
8 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. ...
0
votes
2answers
25 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 ...
0
votes
0answers
21 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 ...
1
vote
0answers
36 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
20 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: ...
0
votes
1answer
56 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 ...
-1
votes
0answers
22 views

Wordpress can't find my new database location [on hold]

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
40 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
26 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
55 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 ...
1
vote
1answer
60 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 ...
1
vote
1answer
45 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 ...
0
votes
0answers
37 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 ...
0
votes
1answer
78 views

Ruby on Rails install and run problem

I installed Ruby + Rails and its dependencies on a fresh installation of Ubuntu 14.04 using the following commands, Pre Install Checklist sudo apt-get update sudo apt-get upgrade Add apt ...
0
votes
0answers
15 views

auth failed (Postfix, Dovecot and MySql)

I set up a mail server with Postfix, Dovecot and MySql and I tried to connect with Thunderbird with an email address that i created in the database and i received this message : Jun 08 09:41:51 ...
0
votes
0answers
91 views

I Get 'Import error : No module named MYSQLdb' in python 2.7. I've tried everything from the other similar thread

The error: import MySQLdb ImportError: No module named MySQLdb. Particulars: OS is Ubuntu 14.04 python 2.7.10 and is the default MySQL 5.5.43 What I've tired: sudo apt-get install ...
0
votes
1answer
17 views

I moved id_rsa and now no programs can find it

I am planning on doing a clean installation of Ubuntu. I am concerned that, when I do a clean installation, my private keys will be lost and I will be locked out of my servers for which I disabled ...
0
votes
0answers
24 views

I tried to install mysql and got this error message about broken package , can anyone suggest a fix?

I tried to install mysql and got this error message about broken package , can anyone suggest a fix? The following packages have unmet dependencies: mysql-server-5.6: PreDepends: mysql-common ...
1
vote
1answer
20 views

Ensure Services start on boot and perform an Security Audit

I'm quite new to Ubuntu Server (14.04) and I need to make sure Nginx/php-fpm/MySQL start up automatically on boot. Where do I need to check to make sure they are set to start on boot and how to set ...
0
votes
0answers
27 views

Fresh Ubuntu install with LAMP and Symfony framework

I have wrestled with setting up a couple (around 5) development servers in the last couple of years and would be looking to do another one soon. However, thinking back, each time I have installed ...
0
votes
0answers
32 views

phpmyadmin could not connect to mySQL database

I had installed phpmyadmin through the apt-get and it was running fine until I installed XAMPP. Now, it keeps giving me "Acess Denied" I removed phpmyadmin through apt-get remove phpmyadmin ...
1
vote
1answer
26 views

Where is .sql file located on Lamp Server using Ubuntu 14.04?

I need to import my .sql file from my MySQL database as an attachment and cannot find where it is located. I am using Ubuntu 14.04 LAMP with Apache 2.4.7. Can anyone help?
3
votes
1answer
53 views

trying to add more table to mysqlcluster getting error ERROR 1114 (HY000) at line 2137: The table 't_email_contacts' is full

Hi I am trying to insert tables to mysql cluster but after some time I get the following error, can you please suggest how to fix this. ERROR 1114 (HY000) at line 2137: The table 't_email_contacts' ...
1
vote
1answer
26 views

Install old versions of Mysql, Apache2, PHP

Is there a way to install old packages of the following versions: apache2: 2.2.12 mysql: 5.1.37 PHP 5.2.10 on Ubuntu 12.04, i386, using apt-get or dpkg?
1
vote
0answers
26 views

Error while installing phpmyadmin package in ubuntu 14.04

root@anonymous-20-a213l:~# apt-get -y install phpmyadmin Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may ...