Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
2 views

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

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 ...
0
votes
2answers
754 views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
1
vote
1answer
8k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld ...
0
votes
1answer
16 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 ...
0
votes
1answer
12 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 ...
1
vote
1answer
39 views

Symbolic Link Error with MySQL Cluster and Ubuntu 12.04

I want to install MySQL Cluster on Ubuntu and I followed this tutorial Install MySQL Cluster on Ubuntu 12.04 LTS. My management node installed successfully, but I am having a problem in my database ...
0
votes
2answers
3k views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access ...
0
votes
1answer
26 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
1answer
3k views

E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

I am using ubuntu 13.10 on evaluation board and my internet is not working. Also i need to install softwares and apt-get install is also not working. Terminal says : E: Unable to fetch some ...
3
votes
4answers
2k views

Mcrypt extension is missing in 14.04 server for mysql

The php mcrypt extension on ubuntu 14.04 shows that it is installed properly, but phpmyadmin says: The mcrypt extension is missing. Please check your PHP configuration. My current php config is ...
2
votes
4answers
4k views

Can't install MariaDB 5.5 or 10 in Ubuntu 12.04. MYSQLD Failed to start?

I tried o install MariaDB on my Ubuntu 12.04 server. First it gave dependency issues and I fixed it by following this question : ...
0
votes
0answers
25 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 ...
1
vote
1answer
26 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
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
13 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 ...
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
2k views

Inserting data into mysql table using a script

I am trying to load data into mysql database using the following script #!/bin/bash DB_USER='my_user'; DB_PASSWD='passwd'; DB_NAME='db_name'; TABLE='rass'; ...
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
44 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
1answer
41 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 ...
3
votes
1answer
336 views

Unable to re install mysql on Ubuntu 14.04: Dependency problems

Ubuntu Unity 14.04 LTS with all lenses removed, except files. (Hate the dash.) I have a LAMP system for web site development. I want to put all my data files in a particular partition that I can ...
0
votes
0answers
21 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 ...
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 ...
0
votes
1answer
27 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 ...
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 ...
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
33 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 ...
22
votes
8answers
39k views

How to install MySQL 5.6?

I just installed Ubuntu 12.10 (amd64), and want to install a recent version of MySQL 5.6. If possible, I would like to install (not upgrade) it the "Debian Way' (i.e., using apt-get or dpkg).
0
votes
1answer
41 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
53 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
73 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: ...
1
vote
3answers
4k views

Debconf errors when configuring mysql-server

When I try to run sudo apt-get upgrade I get the error below. I also get similar error when running sudo reconfigure postfix, which I relly need to run since outgoing e-mail is not working any more. ...
5
votes
4answers
5k views

MySQL Automatic backup tools

I use back-in-time for backuping up my projects. but my Database's are not included. I'd like to backup all database's scheduling by day or hours. Is there any tool to backup MySQL automatically?
0
votes
2answers
4k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
0
votes
2answers
3k views

running XAMPP does not work

i've tried to download XAMPP, untar it in /opt/lampp and launch sudo ./lamp start but i get this output: Starting XAMPP for Linux 1.7.7... XAMPP: Another web server daemon is already running. ...
68
votes
11answers
9k views

What's the easiest way to set up a LAMP stack?

I set up a new VPS instance of Ubuntu and am wondering what the easiest way is to get up and running with a basic LAMP stack (i.e. which packages are required, which configuration options need to be ...
0
votes
1answer
22 views

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

+-----------+------------------+-------------------------------------------+ | host | user | password | ...
1
vote
0answers
27 views

Xampp is not working properly in ubuntu13.04 [duplicate]

I am new to ubuntu operating system and i tried the xampp installation process like the following steps.. cd ~/Downloads sudo mkdir -p /opt sudo tar xvfz xampp-linux-1.8.1.tar.gz -C /opt sudo ...
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)?
1
vote
2answers
21k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I got a problem with mysql server Actually i am not sure im tring to install queXS cati app on my ubuntu desktop i installed mysql server and php5 and when im trying mysql -u root it says "ERROR ...
0
votes
2answers
41 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
34 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
87 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
22 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
31 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
31 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
72 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
1answer
101 views

Auth succeeded No requires line available

Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess; Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely: <Directory ...
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 ...