Tagged Questions

Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
12 views

KUBUNTU can't install XAMPP

I downloaded x64-5.6.3-0-installer.run. I right click on it go to permissions click "is executable", click ok. Then go in Konsole on the download folder: and type sudo su then type: ...
2
votes
0answers
20 views

MySQL (InnoDB) shutsdown same time every day

Ok so recently pushed a large update to my project onto my Ubuntu 14 server. Up until now it's been stable however since the push at exactly 00:36 GMT each day mysql is killed!! Not ideal as we need ...
0
votes
1answer
14 views

Ubuntu Server 14.04 web server not gathering data from mysql server

First of all: I am a beginner, and have only basic knowledge about linux and servers. Also, this question is kind of vague, but i hope you can help. I would be very thankful for all kinds of feedback ...
0
votes
0answers
9 views

MariaDB Galera cluster Master/Master and replication root user

I saw that MariaDB galera cluster not replicate root user password, Is this true? There are other table that Mariadb Galera not replicate?
-1
votes
0answers
17 views

How can I setup c++ so that I can also use mySQL? [on hold]

I don't know if my title is correct but I am using Ubuntu 14.04 and basically I have just installed Netbeans version 8.0.1 with the C/C++ plugin and I want to work with mySQL for an assignment of ...
0
votes
2answers
59 views

Problems installing mysql on Ubuntu 14.04

I hit the following error shortly on entering the mysql "root" password: An error occurred while setting the password for the MySQL administrative user. This may have happened because the account ...
0
votes
1answer
28 views

Mysql installation in Ubuntu [duplicate]

I had seen many answers to install MySQL. I had tried everything. It shows: There's no MySQL already installed Unable to locate package MySQL-server For synaptic, there's no keyword found Unable to ...
0
votes
1answer
12 views

Package list file lists the wrong version of MySQL

ubuntu-14.04.1-server-amd64.list in http://mirror.internode.on.net/pub/ubuntu/releases/14.04.1/ lists version 5.5.38 of MySQL server ...
0
votes
2answers
41 views

How to install MariaDB on Ubuntu 14.10?

After unsuccessful installation of the latest version of MariaDB through repository that is offered by official page (for Ubuntu 14.04) I've tried to install mariadb-5.5 which is already included in ...
0
votes
0answers
14 views

dependency issue while installing phpmyadmin on nginx webserver

I tried to find a solution for this problem for a long time but I cannot find it. Maybe you can help me. I have Ubuntu 14.04 installed on my system and want to use it for web development using nginx. ...
0
votes
0answers
14 views

Ubuntu php5-fpm www.conf pooling

Ubuntu VPS with 4GB RAM running wordpress with nginx, php5-fpm, and percona mysql 5.5 Daily unique visitors 8000 Maximum concurrent connections 90 For the above which is better www.conf (php5-fpm ...
0
votes
1answer
33 views

trouble in installing mysql workbench

i am trying to install mysqlworkbench in my ubuntu using sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1310-amd64.deb.3 but getting following errors (Reading database ... 188276 files and ...
0
votes
0answers
13 views

Problem with i7 notebook running ubuntu - Good hardware

I use ubuntu 14:04 on a notebook for web development. However, about 3 times a day it enters 'bottleneck'. The processing and memory usage go into space. Patiently when I'll see what is happening with ...
0
votes
2answers
39 views

How to install MySQL in Ubuntu Minimal 12.04

How can I install MySQL in Ubuntu Minimal 12.04? When I try to apt-get install mysql-server (as root) even after apt-get update and apt-get upgrade in a fresh install, I receive this: # Setting up ...
0
votes
0answers
37 views

Ubuntu Minimal 12.04 with MySQL installation errors (and minor issues, like the lack of Dialog and ReadLine)

I am trying to start my server with Ubuntu Minimal, because I will not use 90% of the default stack included in Ubuntu Server. But I can't install MySQL, getting erros like these: # Setting up ...
0
votes
0answers
51 views

Error 500 on localhost/phpmyadmin

I recently installed apache2 and phpmyadmin on localhost, and everytime I try to connect to localhost/phpmyadmin I get prompted with an "Enter your username/password". I enter root as the username and ...
0
votes
0answers
11 views

copy the MySQL Connector/J jar file to the domain-dir/lib directory

Where is the MySQL JDBC connector JAR supposed to go? To do this, copy the MySQL Connector/J jar file to the domain-dir/lib directory. For example, copy mysql-connector-java-5.1.30-bin.jar to ...
2
votes
0answers
255 views

MySQL Workbench GUI problems in Ubuntu 14.10

I've recently performed a clean install of Ubuntu 14.10. I got Apache, PHP and MySQL from Ubuntu's repositories, then installed MySQL Workbench (6.1.7) from the Ubuntu Software Center. It almost works ...
1
vote
0answers
44 views

Server slow after Nginx errors and restarting PHP

I have a server with Intel Xeon 2xE5520 2.27GHz, 48 GB Ram, 2x146 GB 15K HDD (Raid) OS Ubuntu 14.04.01, Nginx 1.6.2, PHP 5.5.9, MySQL. Webmin. My website is video portal. Traffic is approximately ...
0
votes
1answer
60 views

mariadb 10 install error on ubuntu 14.04

when trying to install mariadb on ubuntu 14.04 dpkg: error processing archive /var/cache/apt/archives/libmysqlclient18_10.0.14+maria-1~trusty_amd64.deb (--unpack): libmysqlclient18:amd64 ...
0
votes
1answer
22 views

/usr/lib/i386-linux-gnu/libmysqlclient.so.18: no version information available

I wrote a program in C++ (QtCreator) on Ubuntu 14.04 LTS which reads values from Web-API's (curl) and stores them in a MySQL Database (using the MySQL C-API). When I start the program on my Desktiop ...
0
votes
0answers
26 views

Scheduled Cron Back up from EC2 to S3

I have created a script for scheduling sql back ups and store in Amazon S3. Below is the script that I used for taking backups. DATABASES="testdb" testdb_USER=root testdb_PW=root ...
0
votes
1answer
18 views

Why is mysql run in server-client model?

From http://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run Please make sure that you have installed the mysql-server, not the ...
0
votes
1answer
55 views

MySQL Workbench doesn't start

I installed MySQL Workbench from Ubuntu software center and it just doesn't start when I click on it. There's no error shown up. What's the matter? UPDATE: $ mysql-workbench --log-level=debug3 ...
0
votes
2answers
47 views

Installing LAMP - PHP not connecting with MySQL - Why?

Am followoing this amazingly simple LAMP tutorial http://ubuntuserverguide.com/2014/06/how-to-install-lamp-in-ubuntu-server-14-04-lts.html Installing Apache Installing MySQL Installing PHP The ...
0
votes
0answers
42 views

Mysql connection error

I'm newly installed Ubuntu 14.04 on my system. And I individually installed apache2, mysql 5.6.19 and PHP Version 5.5.9-1.whenever I connect to database it's giving error in the console window like ...
1
vote
1answer
44 views

Asking for a sudo password in advance

I have some scripts for backing up data. Some of them need root access, so I use them with sudo. However, sometimes I get confused, e.g. for the mySQL backup, which also needs a mySQL root password. ...
1
vote
1answer
148 views

MySql won't start after installation on Ubuntu server 14.04.1

I'm new to Ubuntu server and MySql. I'm attempting to create a server in VirtualBox that I can use for web development and testing before deploying to a real server. I have Ubuntu server 14.04.1 ...
-1
votes
1answer
48 views

phpMyAdmin doesn't work when installing from repo

I've just installed phpMyAdmin via apt-get and rebooted. When i enter '127.0.0.1:3306' into web browser, i get something like this: I'm totally new to mysql but quite experienced with linux. How ...
0
votes
0answers
19 views

access denied from local host

Ok, I've set up my server and have been having fun designing my website. At the moment I've got several php files that access my MySQL databases. everything is ok client side and the php has no ...
0
votes
1answer
36 views

What is my phpmyadmin's url?

I'm a newbie with linux ubuntu and phpmyadmin. I had an url to access phpmyadmin thru the webbrowser, but since i did not use it for like a year now, i can't remember the url. I believe it was ...
0
votes
1answer
40 views

mysql -h slow ?? how I can correct this?

I have 3 server .1 database server(mysql as database) and 2 normal server called A and B. from A when I try to connect database using the bellow command,the connection is set within a second mysql ...
0
votes
0answers
12 views

my browser is downloading .php files instead of loading them [duplicate]

i already have install all the softwares like apache 2, mysql, php5, phpmyadmin, database. but my browser is just downloading .php files instead of loading them, and on loading localhost/phpmyadmin. ...
0
votes
0answers
14 views

Should I have any concerns when updating my LAMP-server?

I'm using Ubuntu server 14.04 LTS. I'll be installing lamp server with tasksel, though I don't know much about tasksel other than It Is a synaptic package manager. Though, I won't be changing up the ...
0
votes
0answers
57 views

DBI failed to connect mysql

I encountered DBI connection failure to mysql when I tried to install and configure the orthoMCL programs. I would appreciate very much if you can help diagnose and advise some troubleshooting tricks. ...
0
votes
1answer
37 views

mysqld is suddenly taking too much memory and my laptop is getting hotter

I have been using ubuntu 14.04 for a while but really new to linux command line stuffs. I mainly use it for Java/android/web development purposes. Sometimes I notice my laptop gets more hot than ...
0
votes
1answer
51 views

mysql_config_editor not included in MySQL APT Repository?

I've installed MySQL from MySQL APT Repository. Now I want to run "mysql_config_editor" to encrypt my .mylogin.cnf, but it displays: The program 'mysql_config_editor' is currently not installed. To ...
0
votes
1answer
50 views

What path shall I find schema.sql?

I am looking for file named "schema.sql", can someone let me know where can I find it? when I googled a little about it I go one path i.e. /etc/raddb/sql/mysql/schema.sql however it does not exists ...
0
votes
0answers
55 views

MySql crashes happening daily after ubuntu system updates

I have been having this issue for sometime and have no idea why it happens or how to fix it. I'm a Linux novice so that doesn't help. I have a server running on AWS and s used only for hosting ...
0
votes
0answers
51 views

Does VM require Swap? su: fork: Cannot allocate memory

We have Mysql Server in AWS environment in Ubuntu 14.04. Recently our server lost new connectivity like ssh, or scp any connections due to cannot allocate memory. And my existing connectivity to ...
1
vote
1answer
257 views

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different ...
0
votes
1answer
31 views

Not installing softwares after changing the server

I changed the download server from sri lanka server to US server using software and update window. Then I tried to install mysql using this command. sudo apt-get update sudo apt-get install ...
0
votes
1answer
47 views

I am not able to install mysql on ubuntu after unistalling it

I have to install MySQL in Ubuntu for a class. The first time intalling mysql it worked perfectly. However, I accidently ran the sudo mysql_secure_installation command when I wasn't supposed to. I ...
0
votes
3answers
245 views

Postfix/ Dovecot and MySQL

I have an issue in authenticating users using postfix/ dovecot with mysql at ubuntu LTS. Outlook connected to the server but got error for authentication. below is posfix configuration settings: ...
3
votes
0answers
106 views

I can't deploy mysql to LXC:0 with juju

I used "juju deploy --to lxc:0 mysql" to deploy mysql. But ,the container start failed.--"error: container failed to start" so,I used dmesg to look error message: [1318582.474759] init: ...
1
vote
0answers
194 views

MySQL Workbench do not render Columns Tab at ER

I have a fresh install of Ubuntu 14.10, after installing all I need, I started MySQL Workbench (v.6.1.7 build 1788) and in it's ER modeling its not showing anything in Columns Tab when editing a ...
0
votes
2answers
162 views

How to stop mysqld process?

result of ps -e | grep mysqld running htop and clicking on memory usage.. It is taking 33% of 4gb memory. I just want to end the mysqld process.. running sudo pkill mysqld ends the process but ...
0
votes
2answers
119 views

ERROR 1045 (28000) on mysql-server installation [duplicate]

I am new to Ubuntu trying to install MySQL. sudo apt-get install mysql-server php5-mysql then to create database directory structure sudo mysql_install_db Then to secure I use sudo ...
2
votes
1answer
37 views

Trying to sync live data to a backup server

I'd like to take the data from the live system to a backup system (to test new features etc) Piecing together an rsync command, I have the following. How do I ensure everything is copied? Things ...
0
votes
1answer
126 views

What version of “mysql-connector-java” to include in pom.xml for ubuntu 14.04

The mysql server version installed is 5.5.38 as verified by sanchit@sanchit-3560:/$ mysql --version mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.3 But in the ...