Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
4k views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
2
votes
1answer
212 views

sendmail & MySQL

I had MySQL and PHP working good in the nginx server. For mailing purpose I installed sendmail. Now all I get is Your PHP installation appears to be missing the MySQL extension which is required by ...
0
votes
1answer
48 views

Mysql/php connection

I'm a newbie to ubuntu,and im trying to connect the mysqlworkbench(database) with php5.3 if (function_exists('mysql_connect')) { echo "Good<br />\n"; } else { echo "Bad.<br />\n"; } ...
22
votes
3answers
212k 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 ...
1
vote
1answer
371 views

MySQL script does not stop, reboots mysql

I have installed ubuntu 13.10 desktop x64 on my laptop. After the installation I installed MySQL Server sudo apt-get install mysql-server mysql-client Installation wass successful but I noticed the ...
0
votes
1answer
765 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 ...
2
votes
1answer
470 views

what is the command to connect a database remotely from other PC

what is the command to connect a database remotely from other PC. I am running a application in a PC1(client) and storing some content of that application on a database. There is also one another ...
1
vote
2answers
4k views

Cannot compile mysql code

I have the following code #include <my_global.h> #include <mysql.h> int main(int argc, char **argv) { printf("MySQL client version: %s\n", mysql_get_client_info()); exit(0); } ...
3
votes
2answers
325 views

How could I successfully log in under a non-existent user account?

I'm trying to setup ownCloud in a test lab. I somehow managed to create a 'owncloud' user (which is fine). The account has an empty password (I'm not sure how that happened), so I'm trying to set one: ...
2
votes
2answers
6k views

Updating variables in my.cnf

I set lower_case_table_names = 2 in /etc/my.cnf file. I also updated this variable in /etc/mysql/my.cnf file. After setting the variable I restarted mysql server, but still the value is 0, when I use ...
1
vote
0answers
22 views

Ubuntu Mysql suddenly locked me out [duplicate]

I'm experiencing a very weird problem here. I was using a mysql database for developing a rails app and everything was fine. Then I rebooted the computer (Ubuntu 13.10) and found myself locked out of ...
0
votes
1answer
40 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 ...
1
vote
1answer
3k views

What makes mysql service autostart, while it's disabled in BootUp-manager?

The mysql service is not enabled in BootUp-manager, yet it is working after system starts. Is it awaken by another service? How to determine what causes that? EDIT Fix as instructed here.
0
votes
2answers
492 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 ...
13
votes
2answers
27k 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
3k 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
380 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
5k 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
12k 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
342 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
333 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
92 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
340 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:~# ...
10
votes
2answers
8k 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
33 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
64k 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
5k 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
250 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
112 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
194 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
277 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
341 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
7k 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
434 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
856 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
116 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
381 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
675 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
629 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
984 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
572 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
97 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, ...