Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
75 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
44 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 ...
1
vote
1answer
138 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
40 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
136 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
137 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
123 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
101 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
20 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
1answer
62 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
36 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
169 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
133 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
30 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
3k 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
67 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
71 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
207 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
40 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
226 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
42 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
102 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
58 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
45 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
46 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): ...
-1
votes
1answer
153 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
18 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
241 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
136 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
43 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
211 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
171 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
3k 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
395 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
180 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
149 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
2k 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
81 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
4k 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
172 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
67 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 ...
0
votes
1answer
165 views

mysql does not start automatically

I'd like mysql to start on boot but it does not, because I had removed rc.something (don't remember what was it) previously when I wanted it to not start automatically. Now in order to run it I need ...
1
vote
0answers
44 views

Something wrong with my terminal

I am trying to run this command apt-get install mysql-server and it sets up the packages but when it reaches a point where a password input is needed, this is the screen i am getting I can't even ...
0
votes
1answer
316 views

MySQL Server keep shutting down

mysql server is keep shutting down, i am using DigitalOcean 512 MB Memory and 20GB Disk. I am running WordPress and iRedMail. Here are my Error Logs: Version: '5.5.38-0ubuntu0.14.04.1' socket: ...
0
votes
1answer
77 views

Linux Ubuntu Mysql issue

I am not sure if something is wrong with my mysql (runing on dedi server). I might have missconfiguared something, or using a wrong port to connect to, or if it's getting blocked. I'm quite new with ...
0
votes
0answers
197 views

Installing Drupal 8 on a LAMP stack… 404 not found, alternate installation instructions?

I installed a LAMP stack, and followed instructions on how to install Drupal 8, but the page is 404 ing, there is either a problem with the steps, or how I followed them, and I am open to alternate ...
1
vote
1answer
524 views

How to kill MySqlWorkBench process in Ubuntu?

I have installed Mysql Workbench on My machine (ubuntu 14.04 LTS) Lately this software is hanging alot. I want to kill the process I ran the command ps aux but I'm unable to find the Mysql ...
1
vote
0answers
213 views

Why are MariaDB versions different with same configurations?

So, last night I install a fresh copy of ubuntu 14.04 and followed some instructions for installing MariaDB as follows: > sudo apt-get install software-properties-common > sudo apt-key adv ...
0
votes
1answer
78 views

Ok, I have problem with code for adding values into mysql db, there is a posts (db table, java form created in Eclipse)

package sokic; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import ...