Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
1k 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
46 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
51 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
57 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
0answers
37 views

Problems with libmysqlclient

pisio@pisio-laptop ~ $ sudo dpkg -i --force-all /var/cache/apt/archives/libmysqlclient18_5.5.34+maria-1~quantal_amd64.deb dpkg: error processing ...
0
votes
2answers
133 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:~# ...
6
votes
1answer
915 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
24 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
1answer
2k 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
26 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 ...
1
vote
2answers
259 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
0answers
33 views

Package 'libapache2-mod-auth-mysql' has no installation candidate [duplicate]

when i typedin the following command sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin ,the output shown by the termianl is:- Reading package lists... Done ...
0
votes
0answers
105 views

mysql workbench can't create new connection

I can't create new connection in mysql workbench. When i create a new connection it ask mysql root password. When i type mysql root password it show me again "Login Keying password". I hv no idea ...
0
votes
0answers
68 views

TDb failed to establish DB connection: could not find driver

My Mysql is working fine with my system until I had to re-install Mysql using my terminal. Since then I always get the error TDb failed to establish DB connection: could not find driver. I have ...
0
votes
1answer
306 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
56 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
320 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
0answers
30 views

Website can't connect to my server

I have create a user in Mysql with this options: CREATE USER 'useruser'@'localhost' IDENTIFIED BY 'passpass'; GRANT ALL PRIVILEGES ON *.* TO 'useruser'@'localhost' WITH GRANT OPTION; Then i want my ...
0
votes
0answers
89 views

Migrate from MySQL 5.5.34 to MariaDB 5.5.33 for Ubuntu 12.04 LTS

How to Migrate MySQL to MariaDB since I'm taking most of my time turning in Circles. Sorry if this question is to chicken for you guys. Since I'm new with Ubuntu and in MariaDB. Yet most of the time ...
0
votes
0answers
86 views

AutoMySQLBackup - how to store username / password

I'm trying to setup AutoMySQLBackup on Ubuntu 12.04.3 LTS in security conscious manner. I've setup a mysql user with minimum privileges for backups. But when installing AutoMySQLBackup from apt-get ...
0
votes
0answers
73 views

Qt MySQL driver

I installed Qt 5.1.1 using .run file and I couldn't connect to a mysql database (even though QSqlDatabase::drivers() showed it as an available). I found out that I needed to recompile the mysql ...
1
vote
0answers
72 views

Can't purge mysql-server installation

Since I've got no privileged user in my current MySQL-installation on 12.04 LTS I want to re-install the mysql-server completely by using: sudo apt-get purge mysql-server After a very short while I ...
0
votes
2answers
154 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
0answers
62 views

I have Broken my 13.10

I am running Ubuntu 13.10. I was trying to get mySQL workbench to work with my version. One of the solutions I found was to add it to the apt/sources.list file. I tried that, but I have ruined ...
0
votes
1answer
106 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
53 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
0answers
38 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
209 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
35 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
167 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
278 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 ...
0
votes
3answers
1k 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 ...
1
vote
2answers
342 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? Original question: Quiero saber si en la instalación de ...
0
votes
1answer
397 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
86 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
199 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
0answers
153 views

how to update lamp php version 5.3.10 to 5.5

I want to update lamp version. How can I update lamp with php-5.5. I want to develop web applications with PHP, for that reason I need to install a LAMP system, I heard that it's a good idea to use ...
0
votes
0answers
46 views

Mess up between mysql server and phpmyadmin

0 down vote favorite After I installed XAMP on my ubuntu 12.10 it was working fine with mysql. I could start mysql- sudo mysql -uroot -p. I connet it using 127.0.0.1:3306 Recently I installed ...
0
votes
1answer
143 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
758 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
152 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
0answers
50 views

How backup and restore Horde manualy

how can I backup and restore my horde sql database The Databse ist located in /var/lib/mysql/horde There are many *.frm files and one db.opt My Server ist broken, so I want to reinstall it. Can i ...
0
votes
1answer
385 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
0answers
56 views

Any way to recover lost mysql files after ubuntu reformat?

I had to reformat my ubuntu device because seda was encrypted and I lost my keybord kernel. Is there any way that I could recover them. I am wondering because when VirtualBox reformats things, it ...
0
votes
0answers
458 views

(GUIDE) How to install and configure Mariadb on Ubuntu 12.10+

First of all open terminal and type this sudo apt-get install python-software-properties I recommend you to use MariaDB version 10.0.4 Alpha because when im installed it i've got no errors ...
2
votes
1answer
102 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
68 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
238 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
305 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
61 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 ...