Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
6 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 ...
0
votes
0answers
10 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
12 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 ...
0
votes
0answers
6 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
8 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
17 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
13 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 ...
0
votes
0answers
11 views

Can MySql 5.7 be installed in Ubuntu 10.04..? [on hold]

Ive been searching., if its possible to install mysql 5.7 in ubuntu 10.04 but without a luck., can anyone shed a light on this .. Tnx . :D
1
vote
1answer
16 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
13 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
37 views

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

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 ...
0
votes
0answers
45 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: ...
0
votes
0answers
7 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
18 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
22 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
21 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
43 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
80 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
16 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
27 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
20 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
38 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
40 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
30 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
21 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 ...
1
vote
3answers
427 views

MySQL breaks after upgrade from Ubuntu 14.04LTS to Ubuntu 15.04

I recently upgraded from Ubuntu 14.04LTS to 15.04 and during this upgrade, MySQL probably broke. After the upgrade, I ran the command(to start mysql): sudo service mysql start The result was command ...
1
vote
1answer
27 views

MySQL ERROR 13 (HY000) on database creation

The full error is: MySQL ERROR 13 (HY000): Can't get stat of './databasename' (Errcode: 13 - Permission denied) I can't create databases in the mysql shell. I can log in as root just fine and I've ...
-1
votes
0answers
17 views

Integration mysql with elasticsearch aws E2 Ubuntu instance?

I have installed elasticsearch and mysql on aws e2 Ubuntu instance. I have to integrate them can any one help me to integrate mysql and elasticsearch...
0
votes
0answers
284 views

Can't install mysql-server on Server 15.04

I have a fresh VPS at Digital Ocean, imaged with Server 15.04 x64. I'm trying to install mysql-server, but it errors out. Why is this happening? The only system configuration-related thing I did ...
1
vote
1answer
35 views

I can't install mysql on 14.04: “Unable to set password for the MySQL root user”

I have tried the solutions presented in Error installing mysql server on Ubuntu 14.04 but I still can't get it to work. The problem i think is when I install it asks me to set password, but then i ...
1
vote
0answers
34 views

phpmyadmin: unable to connect to 127.0.0.1

I recently installed LAMPP on Ubuntu 14.04. When I start/restart Apache on terminal it shows [OK] but phpmyadmin says "Can't establish a connection to 127.0.0.1". I have tried solutions provided in ...
0
votes
1answer
24 views

LAMP installation [duplicate]

I am trying to install LAMP server on my Ubuntu 14.10 but i am having a lot of problems: the first time i installed it i tried to run my website locally but i wasn't able to access the database ...
1
vote
0answers
48 views

Can't change open-files-limit for mysql on Ubuntu 14.04

I have a LEMP stack on Ubuntu 14.04 with MariaDB. Mysql is a huge bottleneck for my server. I have tried everything of which I am aware to raise the open files limit for mysql. I have added ...
2
votes
1answer
121 views

Systemd Mysql won't stop

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just ...
0
votes
1answer
26 views

Bash sed to read auth into debconf-set-selections for Vagrant VM

I have a Vagrantfile that uses a bash script to set up a VM. I can't get the script to set a password for MySQL using debconf-set-selections with output from an .auth file. Below is an example of the ...
2
votes
1answer
253 views

Upgrading MySQL 5.5 to MySQL 5.6 on Ubuntu 14.04 LTS

I have installed my LAMP with the following commands: sudo apt-get update sudo apt-get install apache2 apache2-suexec mysql-server php5-mysql sudo mysql_secure_installation sudo apt-get install php5 ...
1
vote
2answers
1k views

How to get mysql-server setup on Ubuntu 15.04?

When I was upgrading from 14.10 to 15.04 my mysql somehow broke. When I run sudo dpkg --configure -a After a long wait I get the following response Setting up mysql-server-5.6 (5.6.24-0ubuntu2) ...
0
votes
1answer
31 views

Reset password for mysql in ubuntu: [duplicate]

Refer from this question (Resetting forgotten phpmyadmin password) I am trying to reset the password of mysql installed.But run the third command mysql -u root mysql i will get the error ERROR 1045 ...
0
votes
0answers
30 views

MYSQL How to delete and set permissions to root@localhost

I have a problem using mysql, I keep getting this error message for the root user (access denied) : julian@julian-desktop:~$ mysql -u root ERROR 1045 (28000): Access denied for user ...
0
votes
0answers
26 views

Load balancing apache (Linux) with IIS (Windows)

I've got a server (Linux) with Apache2 (2.4.7), Phpmyadmin VSFTPD and Wordpress, a second Linux server with MySQL running alone and a Windows machine with IIS and Wordpress running. I'm looking to try ...
1
vote
1answer
13 views

An error with MySQL

An exception occurred: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) This is what I get when I try to visit one site! The question is: is it releated to my ...
1
vote
1answer
88 views

MySQL broken. Plugin “FEDERATED” is disabled. Plugin “InnoDB” is disabled

I seem to have horribly broken MySQL on our Ubuntu 14.04 LTS server. We recently installed the mysql-proxy package(we've been trying to set up master-master replication, but we've abandoned that for ...
0
votes
1answer
69 views

How to disable autostart for a mysql?

How to disable autostart for a mysql? I was run sudo update-rc.d -f apache2 remove After it I looked throug all rc0.d - rcS.d and nowhere have found a mysql file. However, the mysql server starts ...
0
votes
1answer
50 views

How to remove MySql apt repo

I was trying to install MySql on my system running Ubuntu 14.04. So I added a MySql apt from the link Steps to fresh install MySql After running into a lot of trouble and realizing the apt uses libs ...
0
votes
0answers
36 views

Installing wordpress with remote access

Probably a very easy question to solve, but is there any recent information on how to install wordpress with remote access? I've found a few online but they're all a few years old and giving ...
5
votes
1answer
45 views

How to find the site that crashes the server?

Probably 1 out of 100 sites crashes the VPS every few days. Apache connections go to few hundreds and mysql requests to few millions. That causes the CPU to be at 100%+ permanently and making the ...
1
vote
4answers
106 views

Unmet dependencies unable to fix

I'm running ubuntu 14.04. I cannot use software center to install anything, even a local deb package so I have to rely on Terminal. Recently I was trying to install mysql-server which generated error ...
1
vote
2answers
22 views

how to use mysql with less and -F

I want to use less as a pager for mysql client. I want to add -F to force quit for short outputs. But I can't combine both correctly. root@jupiter:/# mysql -p -u root -h localhost --pager=less -F ...
1
vote
1answer
31 views

unable to excecute mysql from command line

I've installed xampp. I want to use mysql only and i want to use it in command line not in php myadmin. how can i do that? I've installed mysql again with sudo apt-get install mysql....5.5 so I've ...
1
vote
0answers
43 views

Can`t reinstall mysql on kubuntu

Every time I try to install MySQL I get Setup package mysql-client-5.5 (5.5.41-0ubuntu0.14.04.1) … Setup package mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) … 150415 15:35:15 [ERROR] Can't find ...