Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
10 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 ...
0
votes
0answers
14 views

Q: How to use MySql Databae in QMl to make login [on hold]

Hi i would like to know how i can add my Mysql DB to QML so i can use the user data to make the login and so the user can update his profile.
0
votes
0answers
18 views

Install older version apache, php and mysql on ubuntu 14.04LTS [on hold]

I need to set up my server to work with these apache, php and mysql version. Installing via apt-get, something like apache2 doesn't work for me, cause it will set up latest version available. These ...
1
vote
1answer
18 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
17 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
35 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
28 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
15 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
15 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
27 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
16 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
15 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 ...
0
votes
1answer
52 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
23 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 ...
1
vote
1answer
46 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
22 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
23 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
38 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
0answers
35 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
42 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 ...
2
votes
2answers
56 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
82 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 ...
0
votes
0answers
43 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
22 views

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

+-----------+------------------+-------------------------------------------+ | host | user | password | ...
0
votes
0answers
36 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
91 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
24 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
33 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 ...
-1
votes
0answers
32 views

mySQL server stopped working after changing date to 2114 (year 2038 bug?)

I changed my LAMP server date to 2114: date --set="30 June 2114 13:30:00" mySQL instantly stopped working and I cant restart service: [FAIL] Stopping MySQL database server: mysqld failed! ...
0
votes
1answer
80 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 ...
0
votes
2answers
43 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
6 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 ...
0
votes
1answer
31 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
39 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)?
2
votes
1answer
73 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
0answers
20 views

MySql doesn't install correctly

I recently reset my computer, and when I installed lamp server sudo apt-get install lamp-server^ then I installed Apache2 sudo apt-get install apache2 And then Mysql Server... sudo apt-get ...
0
votes
0answers
18 views

Virtualmin/Webmin on Ubuntu MYSQL server root user doesn't work anymore

I was trying to make some configuration from Webmin on my server and suddenly I don't know what I've done but I receive the following error: The full MySQL error message was : DBI connect failed : ...
0
votes
0answers
36 views

Error while running mysql 5.6 service in Ubuntu 14.04

I need to setup mysql5.6 server in ubuntu 14.04 (32 bit). I downloaded mysql-server_5.6.19-1ubuntu14.04_i386.deb-bundle.tar from official site, then installed with: dpkg -i ...
0
votes
0answers
15 views

mysql hangs website

When I request my website through browswer, the website hangs for indefinite time. If I shut down mysql, then the request is processed very quickly. So I presume that mysql is responsible for that. I ...
0
votes
1answer
18 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 ...
0
votes
0answers
26 views

why does MySQLWorkbench give access denied for the wrong user?

When I try to login with user root and port 3306 I get: Your connection attempt failed for user '' from your host to server at localhost:NULL: Access denied for user 'thufir'@'localhost' (using ...
1
vote
0answers
89 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
177 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 ...
0
votes
1answer
66 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 ...
0
votes
0answers
98 views

initctl: Unknown job: mysql ubuntu 12.04.4

I just updated my Ubuntu and mysql service wont start up. I've tried to re-install million time, i still get this error message: initctl: Unknown job: mysql The error log shows this: ERROR: 1064 ...
1
vote
2answers
50 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
24 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
39 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
22 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
25 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 ...