Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
238 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
507 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
220 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
2k 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
100 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
250 views

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

+-----------+------------------+-------------------------------------------+ | host | user | password | ...
0
votes
0answers
1k 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
504 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
185 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
348 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
vote
1answer
4k 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
316 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
30 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
115 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
93 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)?
6
votes
2answers
4k 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
38 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
114 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
79 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
28 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
37 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
190 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
122 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
441 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
458 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
543 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
80 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
86 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
352 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
34 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
68 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 ...
0
votes
0answers
61 views

Where do I put database and sub-database files in MYSQL? My mysqld.sock is missing, and some phpmyadmin login problems

I used to run WAMP in my old computer. I have gotten into linux and I wanted to take my website from my old computer and put it here and run it with APACHE2, MYSQL, and PHPMYADMIN. I have decided not ...
0
votes
0answers
58 views

phpmyadmin will not let me log in, and mysqld.sock is missing

I have quite a few errors when trying to make a website with LAMP. Error #1: mysql: (I have no idea what's causing it.) mysqld.sock is missing. When I type in $mysql it will say it can't connect ...
0
votes
5answers
5k views

MySQL error: The partition with /var/lib/mysql is too full!

I get this error when trying to start MySQL: The partition with /var/lib/mysql is too full! Here is the output of df -h: Filesystem Size Used Avail Use% Mounted on /dev/sda1 455G 77G ...
0
votes
0answers
21 views

404 when accessing phpmysql

I need some hand holding. I have a website on AWS. It was setup by someone else, so was not involved with the setup process. I have access to the site via winSCP. I know that it is Ubuntu but not ...
0
votes
1answer
1k views

Cannot Install/Start MySQL Server

Okay, I decided to migrate from MySQL Server 5.5.37 to Percona Server 5.6. I ended up removing MySQL Server by the following: sudo apt-get --purge remove mysql-server mysql-server-5.5 ...
1
vote
2answers
50 views

MySQL takes ages to load (only when using WP)

I'm not sure what's happening but it's since a while that I'm experiencing using my dev site (running on a VM) on the local Ubuntu machine. The site runs on a Wordpress instance using MySQL setup to ...
0
votes
3answers
81 views

mysql questions for beginners

ok, I have a few questions regarding mysql. I am currently running ubuntu 12.04.4 LTS command line version. I am looking for a database that I can use. I am confused at this point because I am ...
0
votes
0answers
62 views

Emma - MySQL Server has gone away

I'm using Emma to connect to remote MySQL server. After about minute inactivity I have to reconnect to server to execute query, which is very cumbersome. It looks like this problem appears only when ...
0
votes
0answers
274 views

Problem after installing phpmyadmin in ubuntu 12.04

I have installed phpmyadmin from the following process sudo apt-get install phpmyadmin Then I opened it throghhttp://localhost/phpmyadmin/ But after giving username and password then pressing the ...
1
vote
1answer
189 views

MySQL SSH Connection Setup

I want to connect to a MySQL db (running Ubuntu 14.04) with my Mac (running Mavericks). I will be connecting remote- home to work. How do I setup the ssh connection on MySQL workbench? Also, where do ...
1
vote
0answers
1k views

Apache Timeout (Problem loading page) on localhost

I am running a php script locally in my Firefox web browser. After exactly 300 seconds I get an error page. "Problem loading page. The connection has timed out. The server at localhost is taking too ...
0
votes
0answers
23 views

Test dev website

The task is to drop a few MySQL tables from a dev site and test if that generated any errors on the site, before doing it on the live site. Since the site is also a live site, I included the dev site ...
1
vote
1answer
184 views

Postfix / Dovecot / MySQL- doesn't work!

I have just installed a Mail- Server on Postfix and Dovecot using MySQL to authenticate the user. But if I try to conntect to the Server via Outlook or Thunderbird, the following Error appears in the ...
0
votes
1answer
376 views

Unable to connect to mail server via IMAP and roundcube

I am having trouble getting the final parts of my mail server up and working. I followed this tutorial to get everything set up on the mail server side. I have installed roundcube for webmail and ...
0
votes
1answer
191 views

php5, mysql, phpmyadmin not working in ubuntu14.04

I have already installed lampserver in ubuntu 14.04. when i try to run http://'127.0.0.1', it shows it works. but it does not work when i try to run http://'127.0.0.1'/test.php. I have already created ...
0
votes
1answer
339 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
1answer
106 views

MySQL not working after server reboot?

Because of problem with host company node I migrate from one node to another. Now the server is working, but there seems to be a problem with mysql. In directadmin in MYSQL Management i see this ...
2
votes
0answers
105 views

404 not found error on apache2 [duplicate]

I have installed apache2, actual php version, mysql server and vsftp on my new Ubuntu server. I also installed wordpress and gave the user www-data all rights for /var/www/* and put it to 755. I ...
0
votes
1answer
2k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...