Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
0answers
89 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
40 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
179 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 ...
0
votes
1answer
389 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
42 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
86 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
94 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
118 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
60 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
306 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
27 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 ...
1
vote
0answers
310 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
20 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
27 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
41 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
49 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
68 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
49 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
95 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
103 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?
2
votes
1answer
98 views

Error while installing phpmyadmin package in ubuntu 14.04 [closed]

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 ...
0
votes
1answer
23 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 ...
0
votes
2answers
84 views

How to install bind9 with DLZ unbuntu server 14.04

i am trying to install bind 9 with dlz as the native bind does not have such capabilities. Found a source of compilation on Ubuntu 11.10 but it doesn't seem to work. can't find a decent tutorial or ...
0
votes
1answer
654 views

How to Access MySQL with Python Version 3.4

Python comes in two versions: Python 2.7.6 which has now been superseded by Python 3.4.0. The critical line in Python to access MySQL is "import MySQLdb" Thanks to a response from StackOverFlow, I ...
0
votes
1answer
104 views

How to use INSERT INTO with variables in python

What is wrong in the following code syntax cur.execute('INSERT INTO %s (%s) VALUE (%s)' % (table, Column, Value))
2
votes
0answers
29 views

How can i run two servers in xubuntu 14.04: Mysql server 5.5 & Activemq 5.11

I am developing a web application in netbeans 8.0.2. I have already installed mysql server 5.5 and it was running correctly until i executed the './activemq start' command. The following two error ...
0
votes
2answers
267 views

ubuntu server 15.04: remote access mysql

I install the MySQL from the Ubuntu server cd(15.04). When installation is finished, I found that the configure files under /etc/MySQL/, such as my.cnf and MySQL.cnf are all empty. So I want access ...
1
vote
0answers
50 views

Mysql console client do not take non-ASCII characters

I use Ubuntu 15.04 and mysql client 5.6 My locale is $ locale LANG=ru_RU.UTF-8 LANGUAGE=ru:en LC_CTYPE="ru_RU.UTF-8" LC_NUMERIC=ru_RU.UTF-8 LC_TIME=ru_RU.UTF-8 LC_COLLATE="ru_RU.UTF-8" ...
0
votes
3answers
34 views

Examining EOL characters in a CSV

I have a csv file that I'm intending to import into a mysql table. I would therefore like to make sure I'm reporting it's LINES TERMINATED BY properly. However I cannot figure out what characters ...
1
vote
0answers
233 views

SonarQube installation

I have followed all the steps listed here: http://mamikon.net/blog/installing-sonarqube-ubuntu/ However, in my /opt/sonar/conf/sonar.properties , these 2 lines are missing: ...
0
votes
0answers
18 views

Changing the location of mysql database

I have installed mysql on my machine. What I am looking to do is to store the db in my cloud folder (copy), so that I can connect other laptops to it. So I can connect whilst on one laptop, save my ...
0
votes
2answers
41 views

File mysql.h can't be found

I have installed MySQL in Ubuntu 14.04 but I can't find the mysql.h file in any directory. I don't mean that the compiler can't find it, as mentioned in countless other questions, here but I can't ...
0
votes
0answers
61 views

How to fix LocalHost Error

I am a student of computer science. We were asked to install XAMPP to use MySQL. There was a warning that antivirus software could affect XAMPP. My XAMPP works well but I cannot access LocalHost ...
1
vote
1answer
97 views

Mysql workbench installation failed?

I am unable to install mysql workbench community addition on ubuntu 14.04 I am installing latest version by debian file downloaded from server 1. sudo apt-get install gdebi-core 2. sudo gdebi ...
0
votes
1answer
32 views

MySQL Login Error

I recently installed mysql-server on my Ubuntu 14.04 LTS computer and was able to log in only once. I didn't change any passwords or user information but now when I try and login it keeps throwing ...
1
vote
1answer
132 views

How to update PHP to the newest version(5.5) on LAMPP Ubuntu 12.10 [closed]

I have installed LAMPP about a year ago, I remember that it was very easy because I just had to download a tar.gz file and extracted it to the /opt/ folder it always worked great. Now I want to ...
-1
votes
1answer
370 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
2answers
64 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
64 views

What does (mysql-workbench-bin:4022): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion 'node != NULL' failed means?

I'am running a Mysql server at my Linux system locally running the Debian version, and I start the server and that's okay. Then I start Mysql Workbench and when I execute the Mysql script, I can see ...
0
votes
0answers
76 views

Error while updating with drush

I have an ubuntu server with apache that is going to be the host of our public web site (the site is using Drupal). We currently have a public web site and are moving that site to a new server. I ...
0
votes
1answer
241 views

mysql 5.5 failing to start [ERROR] Can't read from messagefile '/usr/share/mysql/english/errmsg.sys'

Mysql has been working fine until now. Maybe upgrades and broken it. Running 5.5.43 on 12.04LTS. At first there was the error: /usr/sbin/mysqld: unknown option '--explicit_defaults_for_timestamp' ...
0
votes
0answers
207 views

MySQL can't install after bad remove

Some time ago I wanted to have MySQL on my VirtualMachine and I installed mysql-server-5.6. Something went wrong so some site told me that I had to manually purge packages so I did something like ...
2
votes
1answer
248 views

Error Updating MYSQL package

My computer froze and I forgot it was updating in the background so I restarted it. When I rebooted I tried to login (and if I entered the wrong password it said incorrect password), but then the ...
1
vote
0answers
47 views

Unable to get MySQL Utilities (mysqlrpladmin) to work properly under Ubuntu 14.04

I currently have replication running between 1 master and 2 slave servers. When I attempt to run mysqlrpladmin using the "--discover-slaves-login" option and "health" command, it only returns the ...
0
votes
0answers
93 views

Unable to connect to mysql server via terminal

My MySQL server is up and running. But when I try to connect to a DB by typing the command: mysql test I get the following: root@holy-pc:/opt/lampp/htdocs# mysql test mysql: ambiguous ...
1
vote
1answer
58 views

Reset mysql server root password? [duplicate]

I do not care to gain access to any database data, I simply want to reset the root password for the MySQL server on an ubuntu 14.04 LTS vm that I am using for development and testing. Several places ...
0
votes
1answer
109 views

Unable to dump mysql tables to local

I was trying to dump my mysql table using the below command mysqldump --tab=/home/username/Desktop/basic/ --user myusername -p mysql user; But it returned an error saying mysqldump: Got error: 1: ...
0
votes
1answer
300 views

ODBC error connecting to MySQL

I wonder if someone could help with an issue I can't seem resolve with ODBC for MySQL. I am reasonably new to Linux, so any assistance that can be offered would be helpful. If it helps, I am running ...
0
votes
1answer
43 views

tab-completion only works for table names (mysql 5.5 on ubuntu 14.04)

I'm used to having tab-completion for mysql keywords, database names etc in mysql, but in my freshly installed mysql (via 'apt-get install mysql-server') it only works for table names, not database ...
1
vote
1answer
27 views

Ubuntu php and apache development!

I heard that Ubuntu has already available for installation packages as well , confirmed and it really is true , just installed that came with php5.5 , I need php5.2.17 for installation of vBulletin my ...