Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
267 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
38 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
1answer
50 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 ...
0
votes
0answers
190 views

Percona Xtradb Server Cluster 5.6 Setup

Thanks for any help you can provide I seem to be stuck on this error for hours. I am trying to setup a percona 5.6 cluster. I have installed on 14.04 these packages and removed any trace of mysql. ...
0
votes
0answers
107 views

Stuck booting after network adapter change

I have been switching around my VirtualBox network adapters recently, and when I got to the office today my Ubuntu 14.04 server VM got stuck at Starting MySQL [OK] (or whatever the phrasing is of that ...
0
votes
2answers
59 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 ...
0
votes
0answers
37 views

lampp MYSQL linux permissions

I decided to go safe. I am no linux expert either. I edited my.cnf and gave the mysql username (instead of nobody) I set it to 'nugget'. I then added a user named nugget and added it to the group ...
2
votes
2answers
34 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 ...
1
vote
1answer
935 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
0answers
170 views

Locked out of the MySQL database

I'm using Ubuntu 14.04 as my host for my apache-mysql-php server setup. At first, I tried installing XAMPP (from apachefriends.org) and deployed my Moodle and Wordpress sites. However, after a reboot ...
0
votes
1answer
27 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 ...
2
votes
3answers
5k 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
73 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
2k 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 ...
0
votes
0answers
216 views

bugzilla in ubuntu 12.04 server

I am trying to install bugzilla on my Ubuntu 12.04 64 bit server machine. I am following these steps. The problem is that I am not able to find the localconfig file in the bugzilla folder or can I say ...
2
votes
1answer
62 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
237 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
0answers
35 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
0answers
164 views

Local folder for specific MySQL databases with symlinks

Moving specific MySQL databases under home folder using symlink used to work in the past for me (maybe before upgrading from 13.10 to 14.04) but now, following the same procedure, it just does not ...
0
votes
0answers
112 views

installing mysql in other partition

I am trying to install mysql in other partition on fresh Ubuntu 14.04. I'm doing this and getting the errors below. Please help me, I'm new to Ubuntu. apt-get update apt-get install mysql-server ...
0
votes
1answer
202 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 ...
0
votes
0answers
13 views

Install MySQL to Non-System Drive?

Is it possible to install MySQL to a different drive than the system drive? If so, how? If I do something like the following, MySQL will be installed on the system drive. sudo apt-get install ...
1
vote
1answer
28 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
2k 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
2k 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 ...
0
votes
0answers
214 views

MySQL Broken Package on Xubuntu 14.04

Installing LAMP on Xubuntu today with apt-get install lamp-server^, I got the following error: E: Failed to fetch ...
0
votes
0answers
17 views

Insert the data in my XML file in a Database in Linux [duplicate]

My question is how to insert the data in my XML file in a Database in Linux.
0
votes
0answers
178 views

Is there a way to set up zPanel or webmin without uninstalling LAMP first?

I set up my server manually and am pretty happy with it. It's been a job of months, chipping away at it every day, and at this point I don't want to reinstall LAMP. But all server management software ...
1
vote
1answer
197 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
0answers
55 views

Default mysql password for Amazon Ubuntu Apache Php MySQL - 25 - 05 - 2013 (ami-3b117a52)

Hi I just launched a new instance of Ubuntu Apache Php MySQL - 25 - 05 - 2013 (ami-3b117a52) Any idea what could be the default username/password of pre installed mysql? I can log into it by typing ...
0
votes
1answer
85 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 ...
2
votes
2answers
12k 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 ...
0
votes
0answers
876 views

Mysql's my.cnf missing after clean install on Ubuntu 14.04 LTS

I've just installed Ubuntu 14.04. I want to install mysql-server-5.6 but got errors. Setting up mysql-server-5.6 (5.6.17-0ubuntu0.14.04.1) ... initctl: Unknown job: mysql 2014-07-15 03:44:39 0 ...
3
votes
1answer
1k 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 ...
0
votes
1answer
32 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
63 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 ...
1
vote
0answers
114 views

Why my apache service does not work correctly?

I am just a newbie using Ubuntu 12.04 LTS. In the beginning, I just want to install mcrypt, I followed this solution: cd /etc/php5/mods-available ln -sf ../conf.d/mcrypt.ini . php5enmod mcrypt ...
1
vote
1answer
409 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 ...
0
votes
1answer
889 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 ...
1
vote
2answers
258 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 ...
3
votes
2answers
4k 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
0answers
141 views

Running sudo apt-get upgrade gives error [duplicate]

After running sudo apt-get upgrade I got the following error: The following packages have unmet dependencies: gnome-user-guide : Depends: yelp (>= 3) but it is not installed lintian : Depends: ...
0
votes
1answer
466 views

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

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

Mysql failed to start

i tried to restore a db backup to a newly created database, suddenly its starts showing error. Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock so i checked ...
0
votes
0answers
689 views

Lubuntu 14.04: Php5 not working with Apache2

Lately I have been messing around with Lubuntu and today I decided to try to setup a web server (Apache2) with PhpMyAdmin and MySQL Server. This was going great until I attempted to use my test page. ...
0
votes
2answers
307 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
486 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 ...
2
votes
2answers
8k views

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

I'm a newbie here so please bare 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
520 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
0answers
52 views

Mono can't find MySqlConnectionStringBuilder?

This application works and compiles fine on a Windows PC but not with MonoDeveloper. I have added "using MySql.Data.MySqlClient;" and MySql.Data.Dll is added as a reference. I can use other parts of ...