Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
22 views

Thunderbird password error when connecting to Linux Ubuntu Server with MySQL, Postfix, Dovecot

I'm trying to build a server that can host email and allow me to connect into the email server from thunderbird. I've followed these instructions ...
0
votes
1answer
20 views

remove the mysql server

root:~# sudo apt-get --purge remove mysql-server Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f install' to correct ...
0
votes
0answers
39 views

to install numpy i get the following error of unmet depedency

While installing the numpy of python I get the following error: Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f ...
2
votes
1answer
30 views

How can I set a symlink from /tmp/mysql.sock?

I've tried to set a symlink from /tmp/mysql.sock -> /var/run/mysqld/mysqld.sock however whenever I try to do it using the following command: sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock ...
-1
votes
1answer
40 views

Recommanded step for Apache and mysql Performance tuning

I googling lots of sites and forums to solve issue but i didn't get result as my expectation. I installed successfully Ubuntu 14.04 LTS on ProLiant DL360 hardware with LAMP environment. Hardware ...
0
votes
0answers
18 views

I can't restore csv file on ubuntu but restored in windows OS

I have program which creates csv file as backup. When I use my program in windows OS restore works fine I migrated my compiled program on Ubuntu 14.04.2 LTS and with support of mono it works ...
0
votes
0answers
48 views

mysql installation fails

I am trying to install mysql 5.5 / 5.6 on ubuntu 12.04. Each time the installation asks to specify the password then fails with the following error: An error occurred while setting the password ...
0
votes
0answers
25 views

MySQL 5.5 server awkward error 1146

I am a new user of both Ubuntu and MySQL. I wrote a .sql file using gedit, and when I try to load it the MySQL using source /path/to/file the tables are created, but it doesn't insert data into the ...
0
votes
1answer
60 views

Unable to reinstall mysql on Ubuntu

Linux newb, so please be gentle. Tried to start mysql using mysql -u root -p and I got the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
36 views

How to run the MySQL on Ubuntu

i tried the command mysql o/p-ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and sudo netstat -tap | grep mysql o/p=(Not all processes ...
0
votes
1answer
42 views

cant start xamp it gives error message like this

Starting XAMPP for Linux 1.5.3a... /opt/lampp/share/lampp/phpstatus: line 4: /opt/lampp/bin/php: No such file or directory XAMPP: Starting Apache with SSL ... XAMPP: Error 127! Couldn't start Apache! ...
0
votes
0answers
33 views

Adding mysqli to php without recompiling it

I have php compiled and installed in a nonstandard location. I recently encountered an error: Fatal error: Class 'mysqli' not found perhaps because I configured php without --with-mysqli. I added ...
1
vote
1answer
61 views

MySQL will not start

Well, I seem to have totally broken MySQL, possibly through a combination of recently trying to upgrade mysql workbench, which needed me to install some mysql-apt-config package, which broke my usual ...
1
vote
1answer
45 views

How to execute a number of lines using xargs

I have a large sql dump that has 1 insert statement per line. I want to be able to pipe this to xargs so that I can slow down the writes. Basically I want to execute a number of lines, sleep, then ...
0
votes
0answers
9 views

Start mySQL with AppArmor on reboot

When my Ubuntu server (hosted by Rackspace) is rebooted/restarted, mySQL starts automatically as evidenced by phpMyAdmin working properly. However, my PHP code does not appear to work. When I manually ...
0
votes
0answers
22 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
39 views

Server 14.04 unmet dependencies & broken packages

Forgive me in advance as I am new to Ubuntu, I primarily work in a Windows environment trying to learn something new. I am trying to install a LAMP server and so far i have gotten Apache2 installed ...
0
votes
0answers
35 views

Phpmyadmin installation dependency error [duplicate]

I am using Ubuntu13.10 64 bit edition.When i tried to run sudo apt-get install phpmyadmin getting the following error Reading package lists... Done Building dependency tree ...
0
votes
1answer
44 views

How do I upgrade my g++, C++11 features do not work

the following code generates error std::string xyz="whatever"; int x=1; xyz+=std::to_string(x); //this is supposed to turn xyz into whatever1 from whatever Why am I using this approach? Because ...
2
votes
1answer
88 views

MySQL upgrade stuck at version selection

I am trying to upgrade my packages on Ubuntu 14.04 , Then MySQL is asking me to choose the server's version that I want to receive , I am stuck there , can't select any option [Including none] Tried ...
0
votes
0answers
27 views

Upgrading stuck on stage choose mysql | Ubuntu 14.04

Upgrading stuck on stage choose mysql! using sudo dpkg --configure -a did not helped. Got the same choice options for mysql in terminal but enter on OK does not continue to next. Stopping mysql ...
8
votes
1answer
2k views

Package upgrade hangs forever on mysql-apt-configure [closed]

Yesterday it got stuck with an update for MySql. The mysql-apt-config didn't finish for ours so I had to shut down the machine in the end. Today it suggested the same update again, but told me that I ...
0
votes
1answer
27 views

Did I install LAMP?

I just installed Ubuntu 14.10 server. While installing I asked it to install LAMP. But how do I tell if it is working? I tried http://192.168.0.20 which is my server, from a web browser on my ...
0
votes
1answer
26 views

What be the default permissions of mysql directories in ubuntu

default permission of /etc/mysql /etc/phpmyadmin /var/lib/mysql /var/lib/phpmyadmin
0
votes
0answers
80 views

Just installed mysql c++ connector, 'undefine reference to 'get_driver_instance'

This is frustrating I've followed everything from the official mysql connector c++ website. I downloaded the binaries for 64 bit, opened it with archiver. It extracted into a folder 'usr' and had an ...
0
votes
0answers
35 views

Can't login as : ssh root@127.3.138.130 [duplicate]

I am explaining my problem in very simple way I am using Openshift and they have given me PhpMyAdmin for mysql whose ip address is 127.3.138.130 .Since I want to configure file on server I want to ...
1
vote
1answer
83 views

Ubuntu mysql workbench menu shows doubled

I install mysql-workbench in ubuntu 14.04 LTS software center. It install mysql workbench version 6.0.8. In this, menu is doubled So I decided to upgrade the mysql workbench version and add a ...
0
votes
1answer
28 views

MediaWiki installation error: MySQL not identified

After following this answer mysqladmin error while attempting to install MediaWiki on 14.10 I received this error: http://i.imgur.com/Es6oA6G.png. I have been recommended to do: local mysql.so and ...
0
votes
1answer
25 views

Host local database using ubuntu for external applications

I am trying to build an Android application and I need to install a database to store all my data like users, passwords etc. This is the first time when I do something like this and I dont have a clue ...
0
votes
1answer
43 views

mysqladmin error while attempting to install MediaWiki on 14.10

I've been following this installation guide for MediaWiki on Ubuntu (https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu#Step-By-Step) and I managed to get up to Configure MySQL->Regular ...
0
votes
1answer
31 views

Make command run when MySQL database connection is made

I have successfully set up an AMP server (Apache, MySQL, and PHP) and have installed my Content Management System (Joomla!), which I am using to make a small website. The CMS connects to MySQL ...
0
votes
1answer
25 views

Trying to Secure MySQL Replication

I'm trying to do Secure MySQL Replication on my VPS with Ubuntu 14.04. I follow these steps (read only Step 1: Setup SSH Tunneling): ...
0
votes
0answers
52 views

Verifying the Current Version of PHPmyAdmin and Updating if Not

A question was asked on this forum concerning having the latest versions of MySQL, Apache, and PHPmyAdminn. In reviewing this question, I followed up on PHPmyAdmin to verify whether I had the latest ...
-1
votes
1answer
42 views

Where is save data base made in mysql-workbench?

I want know where are saved by default the data base made with mysql-workbench. I want know the directory.
0
votes
1answer
17 views

Trouble in configuring mysql in ubuntu

while trying to configure mysql in ubuntu i got the followig error I tried reconfiguring but it wont work PLease help me on this
0
votes
0answers
65 views

On connecting to MySQL via SSL getting ERROR 2026 (HY000): SSL connection error: protocol version mismatch

I am working with MySQL and generated the certificates to use with MySQL to enable SSL. Here are SSL configs: mysql> show variables like '%ssl%'; +---------------+----------------------------+ | ...
0
votes
0answers
6 views

Every few days the VPS maxes out all it's resources and has to be cold restarted. Methods to narrow down the reason?

CPU load, memory usage, apache usage, mysql usage peak at the same time to incredible values making even logging in via SSH impossible and the server has to be restarted from the hosting interface. ...
0
votes
0answers
51 views

How to shut down (or stop) Apache and My-SQL servers from my LAMP setup? [duplicate]

I just followed the fool proof instructions on how to set up LAMP server on Ubuntu (here: http://howtoubuntu.org/how-to-install-lamp-on-ubuntu). Now I need to know how to not have it running all the ...
0
votes
0answers
21 views

How to configure my LAMP server to POST form data to database

I have installed LAMP server on Ubuntu. I've got apache configured and running just fine. I think my problem is somewhere in the configuration of PHP or SQL.... as I have very little experience in ...
0
votes
0answers
94 views

ISPCONFIG Ubuntu 14.04 phpmyadmin 404 Not Found

After following this tutorial https://www.howtoforge.com/perfect-server-ubuntu-14.04-apache2-php-mysql-pureftpd-bind-dovecot-ispconfig-3-p4, and successfully completed when i try to acces phpmyadmin ...
0
votes
0answers
68 views

DOVECOT: Access denied

I am trying to set up a mail server following this tutorial: http://www.starbridge.org/spip/spip.php?article12#dovecot-sasl-lda-imap-et-sieve I cannot receive emails on my email client (thunderbird). ...
-1
votes
2answers
886 views

How to install ownCloud 8.0.0 in Ubuntu 14.04?

I am following this link to install ownCloud in Ubuntu 14.04 and faced following errors. PHP modules have been installed, but they are still listed as missing?Please ask your server administrator to ...
0
votes
1answer
188 views

mysql-server fails to install after previous failure (and start, and thus configure)

Ubuntu 14.10 64bit sudo apt-get purge mysql-server-5.5 mysql-common && sudo rm -r /etc/mysql Now that we are uninstalled sudo apt-get install mysql-server Reading package lists... Done ...
0
votes
0answers
81 views

Ubuntu 14.04 phpmyadmin : “Login without a password is forbidden” error

I searched lots of Questions and answers here and i applied the solution too. I edited config.inc.php and commented $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; too ,then I restarted apache server ...
0
votes
2answers
64 views

How to reset mysql root password without logging into mysql?

I want to reset mysql root password but I don't want to log into mysql and then reset the password just as follows, mysql -u root FLUSH PRIVILEGES; SET PASSWORD FOR root@'localhost' = ...
0
votes
1answer
455 views

MySQL not starting in Xampp

I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order): sudo chmod 755 /opt/lampp/etc/my.cnf sudo chmod -R ...
0
votes
2answers
30 views

Trying to enter mysql prompt

I have install MySql and now i am trying to get into the prompt of mysql with this command: mysql -host localhost -p but I am getting this error ERROR 2005 (HY000): Unknown MySQL server host ...
0
votes
3answers
1k views

Import error :No module named MYSQLdb

I have a problem so a connection a python to database local of MySQLdb. Message of error is: import MYSQL ImportError:No module named MYSQLdb. This is a script in python 3.4 to connection my ...
0
votes
0answers
57 views

Can't login in phpmyadmin in ubuntu 14.04

I can't login in phpmyadmin using my root password. Moreover, it is not showing any error message too. When I enter password, it redirects to ...
0
votes
0answers
53 views

Cannot reset mysql root password

I can't login to the localhost phpmyadmin neither to the mysql server as root (through the terminal). On both places I get the #1045 error. I followed this answer but the queries were affecting no ...