Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
550 views

Is there a GUI for Apache, MySQL just like XAMPP for Windows?

I know how to install Apache, MySQL, PHP ..etc But I do not want Apache and MySQL to start at boot time. I also do not want to start them manually using the terminal. I am looking for a GUI program ...
14
votes
2answers
34k views

Mysql Job failed to start

I got an error while am up starting the mysql service. /etc/init.d/mysql start Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start Since the ...
2
votes
1answer
4k views

How to start Mysql server after installing from MySQL deb package?

I installed the mysql-5.6.15-debian6.0-i686.deb file on a MySQL site,and I installed it using the dpkg command but after that when I am writing: 1)sudo service mysql start The Answer is: mysql: ...
2
votes
0answers
424 views

Ubuntu virtual memory overcommit apparently hitting MySql performance

I have several installations using Ubuntu Server 10.04 and 12.04 LTS running on Dedicated and VPS with various hosting companies. I am hitting a problem where, especially on migrating to a new server ...
0
votes
5answers
6k views

The best LAMP Stack with a GUI for Web Dev [closed]

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 ...
1
vote
2answers
15k views

install libmysqlclient-dev 5.6

I can't use the mysql ruby gem because I get this error: Incorrect MySQL client library version! This gem was compiled for 5.6.15 but the client library is 5.5.34. (RuntimeError) apt-get is ...
0
votes
1answer
381 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
377 views

Retrieve data from sql into specified place in text

I'm very new to sql and bash-scripting, but even so I've manage to make a sql-table with coming events. And I manage to make a Script deleting old events and export everything in the table to a ...
0
votes
1answer
98 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
356 views

Ubuntu upgrade from 8.04 to 13.10 [closed]

I have a Dell Power Edgge 2950 server running Ubuntu 8.04. Now I would like to upgrade it to to the latest version 13.10. This server is hosting MySQL database and Apache server. root@server:~# ...
11
votes
2answers
10k views

If I reinstall mysql do I lose my databases?

I have MySQL installed on my localhost. What happens if I have a problem with mysql and I want to re-install it again? Do I lose my existing databases?
0
votes
2answers
35 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 ...
10
votes
1answer
79k views

How do I install and enable pdo_mysql and gd extensions for php5?

When trying to install webtrees I get the following output: Checking server configuration PHP extension "pdo_mysql" is disabled. You cannot install webtrees until this is enabled. Please ...
0
votes
1answer
35 views

can i again reinstall java on ubuntu?because both windows and ubuntu is in my system and java is configured on windows?

iam new to ubuntu. i have been working on windows. My question is can we run web application developed in windows on ubuntu? both windows and ubuntu is installed in my system java is congigured on ...
2
votes
2answers
6k views

My Postfix server became a spam server. How can I fix this?

I gotten a VPS recently and I wanted to host my own websites and with that, the ability to send and receive mail. I set up my mail server according to this guide: ...
0
votes
1answer
1k views

install mysql proxy via ubuntu terminal

How do i install MySql Proxy via ubuntu terminal http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-install-binary.html
0
votes
1answer
101 views

command line syntax that will show MySQL details

Is there a command-line syntax that will show details about my installed MySQL (eg. ports, config file paths, etc.)?
0
votes
1answer
1k views

Is there any way to get a MySQL database from a /var backup?

I upgraded from Ubuntu 12.10 to Ubuntu 13.10. After some time, I found that I didn't export all my MySQL databases. Some of them are missing. I still have a backup from my /var/ partition, but I ...
0
votes
2answers
252 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
3k views

phpmyadmin not working because i changed permissions and don't know how to change it back

I installed LAMPP and it worked fine, but i somehow managed to change the permission of the folder /opt/lampp/ to 777 by using this command sudo chmod 777 -f /opt/lampp -R My plans was to do: ...
0
votes
1answer
121 views

Terminal command repeated twice to work

I am very new with linux and ubuntu. Installed it in VMWare Player yesterday and I've been watching some good command tutorials. I've installed mysql and php and some stuff. I've created a database ...
1
vote
1answer
234 views

Issue getting mysql to work correctly

I am installing a custom app that needs mysql, which I already had working so I am a bit confused on whats going on. Anyways here is the error Error loading MySQLdb module: this is MySQLdb ...
0
votes
1answer
291 views

Wordpress permissions problem on apache2 server

I have a windows 7 system. On this system i am running a VM Virtual box LAMP Server with Ubuntu 12.04,apache2, mysql and phpmyadmin... which is accessable via the internet. I installed Wordpress ...
0
votes
1answer
178 views

Changed apache www folder

So I changed it from /var/www to /home/John/Dropbox/www and I also did chmod 755 /home/John/Dropbox/www but it still says You don't have permission to access / on this server. I forgot how to do ...
0
votes
1answer
349 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?
3
votes
1answer
1k views

Auto restarting asterisk and mysql using upstart

I want asterisk and mysql to be able to auto-restart if anything were to happen to it, like if it crashed. I found a guide with what I'm looking for, but it's written assuming that the /etc/inittab ...
1
vote
3answers
8k views

Installed MySQL but still says command not found

I downloaded MySQL's rpm bundle from the site, converted it to a .deb file using alien and installed it by saying sudo dpkg -i mysql-server_5.6.14-2_amd64.deb. However, when I say mysql in the command ...
2
votes
3answers
446 views

Are Apache, PHP and MySQL installed by default?

Are the Apache server, PHP, and MySQL installed by default when you install Ubuntu 13.10, or should you install them separately later?
0
votes
1answer
897 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 ...
3
votes
1answer
117 views

Juju MySQL for WordPress with Percona

Is there any benefit in using Percona as a distro for WordPress? Does it actually allow me to use Extradb or is it still limited to Innobd?
4
votes
1answer
395 views

Juju MySQL adding units vs adding new service with relation

What's the point of adding units to MySQL? Why not just create a new service with relation to the master node? MySQL doesn't support multi-master node so adding units to one MySQL service doesn't ...
0
votes
1answer
767 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
5k 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
716 views

replication checking shell script error

I'm trying to create a Database Replication checking script which checks master-master replication but I'm getting error while executing it. Here is the script #!/bin/bash ...
0
votes
1answer
1k 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 ...
2
votes
1answer
658 views

Not able to find juju charm mysql root password?

I tried to follow the steps mentioned in mysql charm: $ juju ssh <unit> mysql -u root -p enter root password: /var/lib/juju/mysql.passwd But after installing mysql charm, ...
0
votes
2answers
100 views

Ubuntu server and services

I've been using Linux+Plesk Virtual Server as a web server for a while, but I want to give a try on doing it manually, so my question is: I'll have a server which is: 80GB HDD, 4GB RAM, 1TB Bandwith, ...
0
votes
1answer
712 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 ...
2
votes
1answer
522 views

Juju deploy of Charm (Mysql) in MAAS provider failing after successful bootstrap. Juju status stuck in “Pending” state

I have setup a MAAS environment and using Juju to deploy services. I followed the simple juju tutorial of trying to deploy Mysql and Wordpress. The bootstrap node has come up fine without any errors. ...
0
votes
1answer
370 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 ...
1
vote
1answer
17k 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 ...
0
votes
1answer
367 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 ...
3
votes
1answer
739 views

Why does Ubuntu 13.10 still not include MariaDB? [closed]

What is the reason 13.10 still does not include MariaDB? I consider switching from MySQL to MariaDB on 13.10 and wonder what's holding back Ubuntu. PS : Even if MariaDB is not yet included in the ...
0
votes
2answers
2k 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 ...
1
vote
2answers
4k views

/tmp directory: 0 files but shows full?

Related to another post where I was finally able to delete files within /tmp thanks to another poster. However, in the end the sysadmin had to restore a snapshot of a few days ago to get the mysql ...
2
votes
1answer
2k views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
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 ...
9
votes
6answers
76k views

how to correctly install apache2, php5, mysql and phpmyadmin

What is the most correct method of installing apache 2 server, php5, mysql and phpMyAdmin? I installed it this week, and I had a lot problems without solutions, so now that I reinstalled Ubuntu 13.04 ...
0
votes
1answer
865 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
1k 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 ...