Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
2k views

Having problems with MySql

I installed Ubuntu headless server 14.04 yesterday. The only thing, at that point, that I installed was ssh. I updated the server then installed Plesk with their automated install script. This is a ...
0
votes
1answer
235 views

unable to install php5-mysql

Setting up php5-mysql (5.5.9+dfsg-1ubuntu4.14) ... Creating config file /etc/php5/mods-available/mysql.ini with new version cp: cannot create regular file ‘/etc/php5/mods-available/mysql.ini’: No ...
2
votes
0answers
79 views

Access denied in localhost phpmyadmin

I have xampp installed on my local machine which was working fine. Suddenly, im getting this error. I am sure it was working fine, but now i have important database in my localhost(i dont have ...
1
vote
0answers
306 views

Mysql 5.6 not installing/removing/running on 15.10

I have tried to purge mysql and then reinstall it (sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-5.6 ), but it does not work. It looks like a dependency issue. Here is the ...
0
votes
0answers
81 views

can't remove nginx

I have recently upgraded my virtual machine from Ubuntu 15.04 to Ubuntu 15.10. Previously I was running an Apache2 web server with PHP and MySQL installed. Now when I access localhost, or the IP ...
0
votes
3answers
86 views

Errors when installing LAMP on my Ubuntu server (apache2-bin, mysql-client-5.5, mysql-serer-5.5, mysql-server-core-5.5, php5-common)

I tried installing LAMP following this tutorial: https://help.ubuntu.com/community/ApacheMySQLPHP the first command was: $ sudo apt-get install lamp-server^ Which gave me these errors: I tried ...
1
vote
0answers
105 views

Ubuntu xampp, mysql wont start at all

After changing whatever I saw and I found, unfortunately no success. When I installed xampp it ran successfully and both apache and mysql started. But surprisingly after restart below errors begin ...
0
votes
0answers
23 views

Everytime I run a sudo command, the warning comes : sudo: unable to resolve host XXXXX [duplicate]

Some weeks ago, I just changed the apperance of my terminal by making it colorful. It was said to change a particular line in the bashrc file by opening it using this command gedit ~/.bashrc. After ...
1
vote
4answers
220 views

mysql-server taking too much time to be installed and generated failed

I am trying to Run and Install the mysql-server on my ubuntu, it's always stating preparing to unpack ../mysql-server-5.6_5.6.27-0ubunbu0.15.04_amd64deb ... in addition to the above I have a problem ...
1
vote
2answers
177 views

How install or uninstall half-installed mysql-client-5.6 on/from ubuntu 15.10?

I probably corrupted my mysql configuration when I tried to install it (again) using the ubuntu package manager (stuck in the middle, because of the required interaction for which there is no screen, ...
3
votes
1answer
32 views

How to activate MySQL general log in version >= 5.6?

I am having trouble to activate general logs in mysql since version 5.6. What is the proper way to do it ?
0
votes
1answer
160 views

Updating to MySQL 5.6.27 fails but why?

I am using Ubuntu 14.04.3 LTS, I was using MySQL 5.6.24 via (https://launchpad.net/~ondrej/+archive/ubuntu/mysql-5.6) and have just tried to update it but it dies with: 0 [Note] /usr/sbin/mysqld ...
1
vote
2answers
1k views

Why /etc/mysql/my.cnf is EMPTY?

I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server. I was following these instructions. ...
0
votes
0answers
33 views

How can I diagnose a MySQL server randomly stopping?

I have an Ubuntu 14.04 LTS server hosted on a small Digital Ocean droplet (Intel(R) Xeon(R) CPU E5-2630L v2 @ 2.40GHz with 500mb RAM). It runs ~30 very low-traffic WordPress blogs. Twice now I've had ...
0
votes
0answers
62 views

Setting up mysql-server-5.5, every time I am using apt-get?

Every time i use commands like sudo apt-get install sudo apt-get remove sudo apt-get --purge remove and tries to install/remove any package, there is a line > Setting up mysql-server-5.5 ...
2
votes
2answers
80 views

Install mysql-server version 5.5.40-0ubuntu0.14.04.1

I have a test VM with mysql-server version 5.5.40-0ubuntu0.14.04.1 I want to setup another test VM with the same version of mysql-server, but apt-get is not able to find the repository for this ...
0
votes
1answer
149 views

Error occuring while setting up the mysql database in production

I am trying to run command rake db:setup RAILS_ENV="production" But it's giving the following error : DEPRECATION WARNING: Passing a string to ActiveRecord::Base.establish_connection for a ...
1
vote
2answers
94 views

Invoking mysql prompt in ubuntu

I am not able to access the mysql prompt as after typing this mysql - u root in the command line according to the book Agile Web Development with Rails, 4th Edition . Instead i am getting a list of ...
0
votes
2answers
43 views

While accesing mysql in Ubuntu , after entering the correct password? [closed]

I am getting this message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
0
votes
1answer
368 views

Automatic backup of mysql on ubuntu

I have a Ubuntu server with a Mysql daatabase. I would like to set up an automatic backup of this database during the night on another server (ovh for example). I don't know what would be the best ...
0
votes
0answers
33 views

phpmyadmin schema in phpmyadmin is empty and I cannot do anything (select databases or other things)

Good evening, My problem isn't that no matter what internet solution I try to get my xampp server to work, it never does because of phpmyadmin who seems broken beyond repair. Now I cannot even access ...
1
vote
1answer
210 views

Package mysql-server-5.5 is not configured yet

Question I am installing a LEMP stack on a fresh minimal install of Ubuntu 14.04 LTS. When I tried to install MySql sudo apt-get install mysql-server it returned an error with the following ...
0
votes
1answer
207 views

Shell Script - How to run script after mysql is ready?

I have a script (in a .sh file) to run once everytime i logged in. But I have to make sure that mysql service is already running before the main script in my .sh executed. Here is my draft: function ...
0
votes
2answers
177 views

Cannot install Apache. Missing Dependencies that will not install

I am trying to install LAMP on my new server. The problem is that I keep getting a error. Here is what it is: root@178658:~# apt-get install lamp-server^ Reading package lists... Done Building ...
0
votes
1answer
376 views

How do I reset mysql's root password?

I'm trying to get a fresh install of MySQL, how currently I can not connect. I can't figure out what the problem is, nor how to reset the password. Currently, I keep on getting, mysqladmin: connect ...
0
votes
1answer
1k views

How come I get “mysqld.service failed to load: No such file or directory.”

Following this tutorial, I'm getting # sudo service mysqld start Failed to start mysqld.service: Unit mysqld.service failed to load: No such file or directory.
0
votes
0answers
8 views

Recompile MySQL server with debugging enabled

So I am facing this problem, where I am trying to add the .so file to mysql plugin directory and try to create a function from that file and I just keep getting an error and one of the suggestion to ...
0
votes
0answers
116 views

Trying to connect to MySQL and Flask cannot connect to socket

I have looked through all of the information out there and still can get this to work. I am running the LAMP server version (not client) and I am trying to connect MySQL and Flask using Ubuntu 14.04. ...
0
votes
1answer
209 views

trouble installing MySQL on Ubuntu 15.04

When trying the following: apt-get install mysql-server mysql-client I'm getting the following response: debconf: unable to initialize frontend: Dialog debconf: (No usable dialog-like program is ...
1
vote
2answers
131 views

Mysql installation problems ubuntu Precise

I'm trying to install mysql-server package, but I have this error message: /home/nikitasorokin# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading ...
1
vote
1answer
63 views

Mysql installation problems

I'm trying to install mysql-server-5.6 package, but I have this error message: root@ps481138:/home/nikitasorokin# apt-get install mysql-server-5.6 Reading package lists... Done Building dependency ...
1
vote
1answer
48 views

Can't delete mysql-server on ubuntu 12.04.5 TLS

I'm trying to reinstall mysql-server-5.6, but I can't do anyhing, everytime I have this strange message: root@ps****:/home/nikitasorokin# apt-get remove --purge mysql-server-5.6 Reading package ...
1
vote
3answers
53 views

Installing mysql on ubuntu

I have downloaded the mysql server tar file for ubuntu. I tried installing it by refering steps given on internet but it never worked. How can i install it manually in easy way. How to start mysql ...
1
vote
1answer
380 views

Error installing mysql-server-5.5

I am trying to run sudo apt-get upgrade But it gaves me below output. I tried to run sudo apt-get -f install but there isn't any difference. (Reading database ... 621055 files and directories ...
0
votes
1answer
74 views

mysql commands are not working properly from terminal

sir I used to access mysql through command from terminal using mysql -u root -p And after that I also put the password of mysql Now I want to show my databases using the command given below. ...
0
votes
0answers
40 views

Can only connect to mysql server through 127.0.0.1

I have a mysql server running (lamp+ispconfig3). But it's kindof broken; I can only connect to it through '127.0.0.1' if i use localhost i get Can't connect to local MySQL server through socket ...
1
vote
0answers
126 views

Can't open shared library

I am trying to add a function i wrote in C into MySql, in the function I am using 'gmp' library, it compiles correctly and I copy the '.so' file to '/usr/lib/mysql/plugin/' and then log in to mysql ...
0
votes
0answers
17 views

mysql install via apt-get - password? [duplicate]

When I did an ubuntu 15 install I don't recall setting the mysql server's root password. Now tying to log in - mysql -u root -p I'm asked for a pass. I recall some screen that popped up asking to ...
0
votes
0answers
18 views

Problem about username and password regarding phpmyadmin

Sir I wrote http://localhost/phpmyadmin to access phpmyadmin but getting some error.I attatch a screenshot.enter image description here so help me out from this problem.
0
votes
0answers
131 views

problem to install phpmyadmin in ubuntu 14.04 64 bit

I am trying to install phpmyadmin sudo add-apt-repository ppa:nijel/phpmyadmin sudo apt-get update sudo apt-get install phpmyadmin But when I used to check the status it shows unrecognized service. ...
0
votes
0answers
38 views

Server 14.04 - MySQL server does not start after copy in /var/lib/mysql

I have successfully installed mysql-server and start it. Then because i have old backup from another Ubuntu server 14.04 of the MySQL databases i created a copy for the old ones /var/lib/mysql. Then ...
0
votes
1answer
104 views

slurmdbd service can't connect to MySQL at startup, but succeeds manually

I installed slurm-llnl and slurm-llnl-slurmdbd on a Ubuntu 14.04 workstation. I successfully configured SLURM, but am having trouble with the slurmdbd service and the mySQL database After a system ...
2
votes
2answers
1k views

MySQL 5.6 dpkg install error, even after complete uninstall

I am having a error whilst installing MySQL 5.6 from downloaded deb and from apt: nginx@LBNginx:/tmp$ sudo dpkg -i mysql-server-5.6_5.6.27-0ubuntu0.14.04.1_amd64.deb (Reading database ... 121037 ...
0
votes
0answers
19 views

Setting up Postfix and Dovecot with mysql

I followed a guide on Linode for setting up Postfix and Dovecot with mysql on Ubuntu 14.04. After it's all said and done I can't log in under a local client and I get some startup errors that I'm not ...
0
votes
2answers
31 views

MySQL Server not binding to external addresses

I am running Ubuntu Server 14.04 LTS and MySQL server 5.5. I have commented out skip-networking and bind-address in my.cnf. However, when I try to access the MySQL externally, I get error 111 and I am ...
0
votes
0answers
88 views

how to export simple txt log file to mysql DB?

how can i export a simple txt file to a mysql DB ? i want to be able to query for certain iformation and for it to be accessbile for those who have no access on server. i found information of ...
1
vote
1answer
169 views

Mysqld don't start, and don't log

mysqld don't start, as there are no process, and no logs. SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Running mysqld start (as root) ...
0
votes
1answer
37 views

mysql queries in two tier

How to perform the basic MySQL queries using client and data server(Two tier)?? I have tried editing the /etc/mysql/my.cnf file by changing the bind address to 0.0.0.0 then started the mysql and ...
0
votes
1answer
301 views

Easiest way to update Apache, MySQL & PHP on VPS [duplicate]

I purchased a new VPS from bluehost they provided me old version of PHP that's not supporting my website and Its been 1 Week bluehost technical support team refused to do that they are making excuses. ...
1
vote
1answer
446 views

Can't install mysql on ubuntu?

I've tried several methods, from the terminal and now from the software centre and there I'm getting this error: mysql-client-5.6: Depends: libwrap0 (>= 7.6-4~) but 7.6.q-25 is to be installed ...