Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
97 views

Try 'apt-get -f install' with no packages [duplicate]

I am using Ubuntu 14.04 lts OS. So when I go to installed mysql server using below command sudo apt-get install mysql-server I have some error message. This is the error message: Reading package ...
2
votes
0answers
3k views

Mysql fails to start after upgrade

I had mysql working fine, and then I upgraded from 5.1 to 5.5. Now I think it was still working after the upgrade, but I'm doubting myself now that I can't get it started again. I have looked at the ...
0
votes
1answer
523 views

Unable to execute expect script via cron even with the permissions set to 777

I created an expect script that won't seem to run when called by cron. I included the full path in cron when calling it as follows. * * * * * /usr/local/sbin/checkForRemoteTasks >/...
0
votes
1answer
63 views

Decent tutorial needed for setting up simple MySQL client-server system

Could anyone please comment what I have missed during Ubuntu setup, that I am allowed to nothing on my system? Always needing to sudo from command line is not practical if you are not familiar with ...
0
votes
1answer
703 views

Cron job from mysql and send an email with results

I have a ubuntu box hosted and need to setup a cron job for executing a stored procedure and sending the results via email to one address once a week. How can I do this? I am using Mailgun
0
votes
1answer
3k views

Mysql 5.5 server not working

I had Ubuntu 14.04 installed on my system. I recently updated ubuntu and now my mysql does not start and workbench says that mysql server has been stopped. And when i try to start it gives me the ...
0
votes
2answers
837 views

Unable to upload files (pdfs, images) larger than 1 MB

I have recently started PHP and Mysql project development on Ubuntu. In one part of the project I need to upload files. But my script is not uploading anything larger than 1 MB nor does it show any ...
0
votes
1answer
60 views

How to install mysql and other software to ubuntu12.04?

I've just installed Ubuntu 12.04 to my laptop. This is the first time I'm using this OS. Their is no software to watch videos and flash player to watch in web. I'm not being able to install also. I ...
0
votes
2answers
106 views

I cannot remove MySQL

I cannot run MySQL (see below), but also am unable to remove it. kajair@kajair-VGN-CS16G-R:~$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'...
0
votes
2answers
241 views

Have more than one mysql version installed at a time

I currently have mysql 5.5 installed, and working. I'd like to migrate everything to mysql 5.7 (for a number of reasons, but mostly the spatial functions). I would like to have both 5.5 and 5.7 be ...
2
votes
2answers
42 views

Chown Not Responding as I expected.

New to Ubuntu, so bare with me. I recently changed the permission of mysql, /var/lib/mysql so I could save a database in it manually (was only option currently, instead of importing it the proper way)....
4
votes
1answer
2k views

MySQL keeps crashing in Ubuntu 12.04

Every few hours, MySQL crashes on my Digital Ocean Ubuntu 12.04 machine. Below is the errors I am seeing in my MySQL error log. I thought it was a memory issue, so I added a swap, but that didn't fix ...
0
votes
1answer
36 views

2nd harddrive, /var/lib/mysql ownder is nvidia-persistenced when mounted, mysql when booted?

I have a second HDD that was my old OS. When I boot it the /var/lib/mysql folder is mysql:mysql but when I mount it (LVM) in my new OS it is nvidia-persistenced:vboxusers. I want to do a cp -pr to ...
6
votes
3answers
16k views

Mysql strange installations problems (logger: command not found)

This problem is really strange, I have tried many ways to solve but nothing worked. My last output was: Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
91 views

Just setup ubuntu as webserver, what about my AMP setup on my other computer do I remove it?

My question is now that I have setup the Ubuntu web server do I have to remove the Apache Mysql and php from the laptop so it doesnt conflict with the server and/or can I migrate the working settings ...
0
votes
1answer
6k views

How to install Zend Framework 2 on ubuntu?

I'm looking for a tutorial on how to install Zendframework 2 on Ubuntu 14.04, and also a tutorial teaching how to use ZendFramework 2. Could someone help me? If it is useful to know, I'm with XAMPP ...
2
votes
1answer
97 views

A question on mysql command

I want to config postfix. I followed these instructions. On the first step I saw this mysql command: mysql > GRANT SELECT ON servermail.* TO 'usermail'@'127.0.0.1' IDENTIFIED BY 'mailpassword'; ...
0
votes
1answer
537 views

How to compile/install bind9 with DLZ (MySQL) support?

I am wondering how to compile or install a version of bind9 that supports DLZ (specifically, MySQL) on Ubuntu 14.04. According to my internet research, bind9 doesn't support it by default. Does anyone ...
0
votes
1answer
123 views

unsure of owncloud mysql password and database

I've recently attempted to make my pc an owncloud server. I attempted to logon on the same machine I am hosting it on. However, I first need to enter a mysql password, database name, etc., and I don't ...
0
votes
1answer
432 views

Why access denied for user root right after I set up its password?

I have installed php and mysql. But cannot set the root password. This is what I've done so far: sudo apt-get install mysql-server sudo apt-get install mysql-client After that: mysql -u root -p ...
1
vote
1answer
43 views

Find out what php librariers are installed

I really hope this question is no duplicate, but I just can't find an answer. I'm new to Linux and PHP. I have a manual telling me that I need PHP with certain libraries installed. Is there a ...
-1
votes
1answer
8k views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...
0
votes
1answer
3k views

How to install PHP MySQL extensions

I just installed a new server which comes with php 5.5. however one of my older projects requires php 5.3. So I installed php 5.3 with wget http://www.php.net/get/php-5.3.28.tar.bz2/from/a/mirror ...
1
vote
1answer
446 views

libmysqlclient error. No file (even though its there)

Trying to launch a program. I get the error as follows: ./theforgottenserver: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory ...
0
votes
1answer
233 views

How to connect from MySQL to Web Application [duplicate]

I have been trying to setup a local instance for a web application. I am new to MySQL and I can't understand how to actually connect this database to the actual web application sitting in the /var/...
4
votes
2answers
42k views

How to downgrade PHP from 5.5.9 to 5.4 in Ubuntu 14.04 (Installed with LAMP)

I need to downgrade my PHP version from 5.5.9 to 5.4 (using Ubuntu 14.04), because I have a code that's using mySQL (which is deprecated in 5.5.9), and I cannot change that code. Is there a way to do ...
7
votes
1answer
2k views

MySQL 5.6 depends on client 5.5

I've installed Mysql-(server/client)-5.6 on Ubuntu 14.04 LTS server but for some programs I need mysql-client (automysqlbackup and postfix for example) root@server:~# apt-get install ...
1
vote
1answer
51 views

How do i export a database in ubuntu to specified location using terminal

I get a blank screen since i have installed the ATI graphic drivers. I tried a lot of things restore my laptop but all in vain. Only formatting seems to be the other option. So i want to export my ...
0
votes
1answer
173 views

Apache status suddenly stops

I have a problem with my apache, I am running Ubuntu server 12.04 on a VPS. I have a basic LAMP stack, my problem is this, every few days apache will just stop and I will just notice this if I checked ...
0
votes
1answer
1k views

Why can MySQL not use /run/shm as tmpdir?

I read that using RAM for MySQL's temporary tables should improve performance. I tried to create /etc/mysql/conf.d/local.cnf with the contents: [mysqld] tmpdir = /run/shm But restarting mysql fails,...
0
votes
1answer
2k views

Could Not Connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am new to Ubuntu and using Ubuntu Server 14.40 LTS. I am trying to connect my mysql database to show database data on a php file but I am not able to connect it. I am getting error Could Not Connect:...
1
vote
2answers
739 views

sending email from cron with correct format

I am stuck when sending email in correct format from cron jobs executing my php script which fetches records from mysql database. i have a php script which fetches records from database and renders ...
4
votes
2answers
9k views

Making Apache secure on Ubuntu 14.04

I am wanting to host a small site at home and have installed Apache etc like this : sudo apt-get update sudo apt-get install tasksel sudo tasksel install lamp-server That all worked and everything ...
0
votes
1answer
2k views

Question about multiple 'root' users in mysql's users table

+-----------+------------------+-------------------------------------------+ | host | user | password | +-----------+------------------+---------------...
0
votes
2answers
1k views

debian.cnf file location in Ubuntu 14.04

Where can I find the "debian.cnf" file in Ubuntu 14.04? It was under "/etc/mysql/debian.cnf" in Ubuntu 12.04. Is there some location changes or name changes ? What I want is to reset MySQL root ...
2
votes
2answers
1k views

Is securing phpMyAdmin with .htaccess considered sufficient?

I have just installed Linux / Ubuntu for the first time in order to learn, and to get some experience with LAMP servers. I also installed phpMyAdmin and used an .htaccess file (stored in /usr/share/...
12
votes
2answers
39k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm a newbie here so please bear with me. I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be ...
1
vote
2answers
1k views

Can't upload .sql file

Environment: Ubuntu 14.04 (local dev machine running under VirtualBox) Apache/2.4.7 (Ubuntu) phpMyAdmin 4.0.10deb1 I'm getting the below error. I've been reading the manual and searching posts ...
0
votes
1answer
642 views

How to install mysql, mysql workbench on Ubuntu 14.04

I am having problems trying to install mysql workbench. Says there is no mysqlclient installed, but I already have. and when you run mysql server also gives error. I am using mysql 5:16:17. How do I ...
1
vote
0answers
553 views

XAMPP (LAMPP) on Ubuntu Touch

Can I install and run XAMPP (LAMPP) on Ubuntu Touch on a Nexus 10 in order to host a local website (that needs PHP and MySQL)?
13
votes
3answers
24k views

unable to reset root password of mysql

I need to reset the root password of my local mysql installation but it woudln't let me. I've tried this: $ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld ...
0
votes
1answer
81 views

Query mysql return an error Incorrect key file for table

I have a site in joomla I hosts locally on an Ubuntu server. When a query is executed by mysql, I get the following error: Incorrect key file for table '/tmp/#sql_6ef4_1.MYI'; Here is my ...
1
vote
0answers
178 views

Apache and MySQL bringing server to a crawl several times a day

I am having difficulty troubleshooting a bottleneck problem with my Ubuntu 12.04 server. I run a very small intranet website off of the server. There are web requests (SOAP, HTML, REST, etc) at a ...
3
votes
2answers
2k views

How to make an executable file to update mysql database?

I have an Ubuntu server that is hosting my web application. But due to some security reasons it is not visible through Internet. The customer needs to update the database and update some values in it,...
1
vote
1answer
1k views

Communication between Linux Containers (lxc)

I have a container for my Apache webserver, and another one for my Mysql server. I have given them 2 static IPs NAME STATE IPV4 IPV6 AUTOSTART --------------------------...
2
votes
2answers
151 views

How do I check services requiring a restart (of services, not the machine) by installing updates to other packages

If I run sudo apt-get upgrade then I get shown a list of packages and if any of these are services, they may need to be restarted (which is done automatically when installing the updates). How can I ...
0
votes
1answer
518 views

MySQL Ambiguous Option issue

MySQL is starting correctly as a service, and my WP instance / phpMyAdmin connects to it successfully. However, I've managed to screw something up such that when I try to log in from the prompt, ...
0
votes
1answer
2k views

Ubuntu Server 14 MySql php connect problem

I have ubuntu server 14.04 installed along side Apache, PHP5 and MySQL server all together. I can gain access to the server using putty and the mysql database using Heidi Sql remotely. On my laptop, ...
0
votes
1answer
139 views

After installing mysql-server, and doing $mysql, mysql won't start. Mysqld.sock missing

First, I installed mysql-server Next, I did $mysql I was going to add a database and edit some stuff. But I got this error: ERROR 2002 (HYOOO) : Can't connect to local MySQL server ...
0
votes
1answer
162 views

Starting mysql server problems

I am trying to get mysql (server?) to start. This is what I keep on getting: Rather than invoking init scripts through /etc/init.d, use service(8) utility, e.g. service mysql start THEN when I do ...