Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
692 views

Restoring MySQL files to new disk 14.04 - permissions?

I am rebuilding my computer with a new disk and have a backup of my MySQL db's - I have moved them to /var/lib/mysql and when I try: sudo /etc/init.d/mysql start MySQL refuses to start - the error ...
0
votes
1answer
554 views

Can't get latest PHP or Pear in Ubuntu 12.04 LTS

I'm attempting to install PEAR, and other components.. but getting the following. $ sudo apt-get install php5 libapache2-mod-php5 php5-mysql Reading package lists... Done Building dependency tree ...
0
votes
1answer
64 views

I have installed mysql on ubuntu 13.10, but don't seem to have rights to do anything?

This is possibly a problem that affects lots of users, I have have found similar posts, but none of the solutions have worked for me. I have installed mysql on my ubuntu 13.10, however I do not seem ...
0
votes
2answers
281 views

Apache unable to connect to MySQL

I installed apache server (this story). I cannot connect with remote (I tried local too) mysql server. After a long loading page I get error MySQL database connect failure. Mysql server is far from ...
0
votes
1answer
340 views

Unable to connect - Apache2 in Ubuntu 12.04 VirtualHost

I have followed the tutorial from here https://www.digitalocean.com/community/articles/how-to-set-up-apache-virtual-hosts-on-ubuntu-12-04-lts to set a local website. I just changed the port 80 to ...
0
votes
0answers
27 views

Error when installing mysql on ubuntu [duplicate]

I get This error when I try to install MySQL on ubuntu: sudo apt-get install mysql-server [sudo] password for xxxxx: Reading package lists... Done Building dependency tree Reading state ...
0
votes
0answers
29 views

How to solve mysql dependency problem [duplicate]

Hi I ran the following command sudo apt-get upgrade However I'm getting the following You might want to run 'apt-get -f install' to correct these. The following packages have unmet ...
0
votes
1answer
126 views

No reaction on service mysql start, init script works

After upgrading Ubuntu from 12.04 to 13.10, the MySQL server (now 5.5) does not start/stop with service mysql start|stop. When typing /etc/init.d/mysql start, everything works fine. Once it does ...
0
votes
0answers
44 views

Setting Max Connections in MySQL server Globally [duplicate]

I installed my UBUNTU 12.04.4 LTS X64 yesterday and didn't installed anything except mysql-server and mysql-client. But htop showing 20 mysqld identical processes. *--Process----- MEM%---VIRT --- ...
0
votes
2answers
2k views

Could not open connection to host (ubuntu server) on port 23, 5432, 3306

I have recently installed few packages for telnet, mysql and postgreSQL. I can access all these service locally on the ubuntu server but somehow I am not able to access these services from other ...
0
votes
1answer
1k views

Unable to install MySQL. Held broken packages [duplicate]

I tried installing MySQL using sudo apt-get install mysql-server, and I get an error saying Some packages could not be installed. This may mean that you have requested an impossible situation or if ...
0
votes
1answer
419 views

Why automatic installed mysql 5.5 when i install mysql workbench 6.0.9 from deb file using ubuntu software center

I am using Ubuntu 13.10 and already installed mysql 5.6.16 on it. I have downloaded mysql workbench deb file (mysql-workbench-community-6.0.9-1ubu1310-amd64) from mysql web site. Now when I run this ...
0
votes
2answers
527 views

Server crashed a few times due to lack of memory - how can I find out how much is available to each process? [duplicate]

We had a huge spike in traffic with lots of these errors: Feb 17 10:44:13 111488 kernel: [8275767.506198] Out of memory: Kill process 20577 (apache2) score 52 or sacrifice child Feb 17 11:02:06 ...
0
votes
1answer
84 views

Mysql died and won't start

I am working on Ubuntu 12.10 server with nginx, mysql and unicorn installed. There is something wrong with Mysql and has stopped working. Log message from /var/log/mysql/error.log Attempting ...
0
votes
1answer
217 views

mysql with ubuntu 13.10

I have a problem with mysql-server and client after a wrong configuration. I tried uninstalling both but I get an error when I uninstall mysql-server: start: Job failed to start invoke-rc.d: ...
0
votes
2answers
929 views

Mysql query browser or any Mysql gui tool in Ubuntu

I have installed Ubuntu 13.04 and now fully dependent on it. I have worked on mysql query browser in windows to run queries and procedures and programmers ,i could not find any other alternatives in ...
0
votes
1answer
370 views

Unable to create a file in a certain location on Ubuntu

I'm trying to create a text file as below... mysql --host=localhost --user=root --password=11111 database1 << EOF SELECT * FROM table WHERE status = 1 INTO OUTFILE '/home/user/feeds/file.txt' ...
0
votes
1answer
77 views

php and mysql issues

I've recently read Wallace Wang's “Beginning Programming for Dummies, 7 books in 1” and found it to be very enlightening, as it highlighted various differences between the three main operating systems ...
0
votes
1answer
213 views

12.04.4 + MySQL 5.5 + Wordpress - MySQL Service Fails to Start

It appears that the issue is around the MySQL services starting as I receive the following in my /var/log/syslog when I attempt to restart the mysql service: Jan 17 08:19:38 blog kernel: [ ...
0
votes
1answer
79 views

cron not outputting correctly?

Please forgive my ignorance. I have searched, but perhaps I’m not sure really what to search for in order to answer my question myself, so I’m turning to this forum for a little guidance. I’ve ...
0
votes
1answer
520 views

How to set up Apache/MySql/Django environment for development

I've only been able to find tutorials to set up Apache/MySql/Django on servers, but I'd like to set up an environment on my machine for development. Does anyone have any good tutorials or suggestions? ...
0
votes
1answer
847 views

Installing libmysql on Ubuntu Server 12.04

I really need help installing the dependency of this, which is libmysql (here) I really have no idea how to install it. The author requires me to put it in a specific directory, but I have had no ...
0
votes
1answer
1k views

Can't Connect to MySQL via CLI or phpMyAdmin, but WordPress still connects fine

This is the first time I've had to reach out for a question -- I'm truly stumped. I have mysql up and running on a linux server (Ubuntu) and this morning tried to login to phpMyAdmin. I received an ...
0
votes
1answer
651 views

How can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?

I am setting up a daily backup of a MySQL 5.6.14 database using mysqldump on an Ubuntu 12.04 Precise server. I created the credentials file in the root home directory (.mylogin.cnf) according to the ...
0
votes
1answer
581 views

Connect to mysql database on Ubuntu host from windows guest

I have Ubuntu 12.04 on my laptop and have a Windows 7 guest on (VMWare). I would like to connect to the mysql database on Ubuntu host from Windows guest.Kindly tell me how to do the same. I have tried ...
0
votes
1answer
38 views

autogenerate javascript from mysql

I have a site where I can upload images with some info (startdate, enddate, duration, url) I want to make a SlideShow that choose those pictures that is > $startdate && < $enddate. And I ...
0
votes
4answers
2k views

The best LAMP Stack with a GUI for Web Dev

I'm a spoilt windows user and always have used a WAMP stack with a GUI that allows me to start or stop apache and mysql services. I find it really hard switching to the LAMP command line and was ...
0
votes
1answer
140 views

Mysql service status

I recently was trying to restart MySQL when I ran into an error where it was hanging at "MySQL stop/waiting" I then went to uninstall MySQL, but even with mysql-server and mysql-client uninstalled I ...
0
votes
1answer
74 views

How to allow all people to access mysql database?

How can I set to allow all the people to access mysql databases??I mean like how to set wildcard so that anyone can access mysql databases.
0
votes
2answers
29 views

How to reinstall services?

I made a mistake and deletes the etc/mysql/ directory. I installed lamp-server again (sudo tasksel install lamp-server) but I still don't have the etc/mysql directory and some of other mysql ...
0
votes
2answers
221 views

phpmyadmin just will not work fully

Right, I've spent upwards of 8 hours on this and I just can't solve it! Firstly, I couldn't log in to phpmyadmin with every combination of possible default password and usernames until I had to go ...
0
votes
1answer
271 views

How to install mysql 5.5.34 completely from shell?

I'm try to install mysql 5.5.34 from shell in my server, I'm new for linux.Can anyone explain it simply?
0
votes
1answer
749 views

Can't Install php5-msql

Hello friends I'm finishing the process of installing Apache/Php/mysql installations but this shows up: # sudo apt-get install mysql-server php5-msql Reading package lists... Done Building ...
0
votes
1answer
460 views

Why isn't the cppconn folder in /usr/include?

I am new to C++. I am trying to make a MySQL connection. I found that it requires mysql-connector. I installed boost-dev-all . I have put my mysql-connector in local directory ~/bin. I have ...
0
votes
1answer
3k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
0
votes
1answer
864 views

Firewall blocking mySQL port

I am trying to connect to mysql through node.js program but it throwing an error. I am not able to connect to mysql on port 3306. I already have apache installed on my PC. I have tried ...
0
votes
1answer
467 views

127.0.0.1:9051 doesnt work after apache, mysql, php installation?

I have installed apache2, mysql, and php and now it doesn't let Vidalia run on localhost. I tried to change the TCP connection (controlport) to any other ip 192.168.0.40 and tried to change the ...
0
votes
1answer
227 views

Where is my lock file? mysql [duplicate]

Below is my console out put I have no idea how to proceed with this, Can anyone provide some direction? apt-get install mysql-server Reading package lists... Done Building dependency tree ...
0
votes
1answer
310 views

Messed up installation of mysql-server - cannot complete installation or deinstallation

apt-get got stuck while installing mysql-server. I don't know why but it just stopped working and never continued. I had to reboot the machine in the middle of the setup process. Now, if I try to ...
0
votes
2answers
1k views

OpenVZ Ubuntu 13.04 VPS - unable to install MySQL

Today I bought a VPS from edis.at, OVZ Starter, and I installed Ubuntu 13.04 x64 on it. On a fresh install, running apt-get install mysql-server, freezes apt-get. After setting the MySQL root ...
0
votes
0answers
20 views

Can't remove phpmyadmin [duplicate]

I am having great difficulty trying to remove this so I can then start over building a forum. But I made some errors and so have removed some stuff but yet to remove this. This is one of the error ...
0
votes
1answer
816 views

ubuntu 12.04 lts secure lamp server

So ... i've been been unfortunate with my linux VPS server running 12.04.3 lts. I had a bad php script running that basically opened up for a mysql injection. And because of a stupid configuration ...
0
votes
1answer
767 views

Install ODBC Driver under Ubuntu

I have the latest version of MySQL and NetBeans installed on my system. I also have the iODBC driver manager installed. I need help with installing an ODBC driver and creating a DSN for my JSP ...
0
votes
1answer
248 views

Python: comparing two iterating tables

I don't know if asking Python questions here is right or not but here I got. This thing has me stumped. I have a python script which connects to a MySQL DB, and takes a table of datetime results, so ...
0
votes
1answer
27 views

Installing with source and package

I recently installed mysql and apache from source, and php using apt-get. I wanted to install php with source, so I removed php package but accidentally removed packages named "mysql-common ...
0
votes
1answer
102 views

No matter what I researched and did I can't connect to my MySQL server

Ubuntu installed MySQL for me through LAMP. When I connect with SSH I can login with the root user but not the user i created myself. When I use HeidiSQL I can't login with anything. I ran these ...
0
votes
1answer
492 views

any way for auto-tab in mysql?

Using MySQL version 5.5 in Ubuntu 13.04.is there any way for enabling auto-completion with TAB in mysql ? I'd like to auto-tab for table names,database names,commands etc ,.
0
votes
2answers
1k views

Automatically deleted MySQL database table when restart server

I installed LAMP server on my Ubuntu 12.04 Server PC. I changed the database storage location using my.cnf. After I changed the location it's working fine. But if I restart my MySQL database is ...
0
votes
1answer
167 views

Build Apache module in C

I've a problem in building a Apache c module. For compiling the module, i use the statement: sudo apxs2 -I/usr/include/mysql -i -a -c mod_aledav.c and the module seems to be compiled correctly, but ...
0
votes
1answer
824 views

Setting up websites with Ubuntu 13.04 server and Nginx

I'm trying to setup 2 websites on my server ---> A_website and B_website I don't have a domain name registered and I just want to use the site privately so I'll be accessing it via the static IP ...