Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
2answers
4k views

Mail Server Can't Receive Email But Can Send Email - Postfix, Dovecot, MySQL

I have server where I want to set up a mail server to let me receive and send email from my domain. I'm currently having a problem where while I am authorized to send email from the server, but ...
3
votes
1answer
10k views

Remotely access mysql db on vm from windows as host [closed]

I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from the Host(windows) machine. Ubuntu is connected to the router via bridge. I can ping it ...
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?
3
votes
3answers
5k views

Cannot get mysql to work/start even after clean install

I am completely stumped right now, whilst I am not an advanced user, I know my way around Ubuntu and so tried to look into things with the help of certain forum topics. The Problem: Today, quite ...
3
votes
2answers
10k views

mysql not starting

I have a server running on rackspace.com, it been running for about a year (collecting data for a project) and no problems. Now it seems mysql froze (could not connect either through ssh command line, ...
3
votes
3answers
402 views

What to use to monitor MySQL for corrupted tables?

What is a good program to monitor mysql tables for corruption, one that would email me as soon as there is a corrupted table? I'm not looking for mysql workbench or admin to manage the database. But ...
3
votes
0answers
34 views

upgrade process stuck for too long while Preparing to unpack …/mysql-server-5.7_5.7.12-0ubuntu1.1_amd64.deb

I tried to do upgrade and its been unpacking for too long (20 minutes) is it normal?, not responding to ctrl+C too.What to do next? shubhendu@shubhendu-HP-Pavilion-g6-Notebook-PC:/opt$ sudo apt-get ...
3
votes
0answers
28 views

I need a correct help for MariaDB SSL support

I have to make my MariaDB authentication a bit safer than default. I tried to set up SSL support for this, but found only an old howto here: How to enable MySQL SSL on Ubuntu I followed it, however ...
3
votes
2answers
63 views

Shell script password with special chars

I've build a shell mysql backup script which works very well. It only has problems with passwords with special chars like this: xgT{uic[Is?uJ+. Here is the important part of the script: #!/bin/sh ...
3
votes
0answers
101 views

My Akonadi server keeps crashing on startup. How do I fix this?

I am trying to make KPIM work on my kubuntu (Wiley) machine. When I try to start akonadi (the db server) it tells me it is not registered with dbus and fails to start -- heres the output of the ...
3
votes
0answers
248 views

I can't deploy mysql to LXC:0 with juju [closed]

I used "juju deploy --to lxc:0 mysql" to deploy mysql. But ,the container start failed.--"error: container failed to start" so,I used dmesg to look error message: [1318582.474759] init: maas-...
3
votes
0answers
2k views

MySQL Workbench do not render Columns Tab at ER

I have a fresh install of Ubuntu 14.10, after installing all I need, I started MySQL Workbench (v.6.1.7 build 1788) and in it's ER modeling its not showing anything in Columns Tab when editing a table,...
3
votes
2answers
4k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php aswell....
3
votes
0answers
582 views

Using gnome-keyring with svn via ssh and mysql-workbench

Problem: mysql-workbench fails to connect to the keyring to connect to mysql. I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
3
votes
0answers
2k views

Why can't I reinstall MySQL? [closed]

List item I've been looking all around the Internet for an answer but didn't find anything. I hope you can help me now. I have a server with MySQL. From one day to another, MySQL didn't let me ...
3
votes
0answers
428 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table '...
3
votes
0answers
3k views

MySQL Workbench for Ubuntu 12.04 LTS [duplicate]

Possible Duplicate: How to install MySQL workbench? MySQL workbench is not available for 12.04, it is at the moment available upto 11.04 only. I tried to install the Workbench 11.04 version ...
3
votes
0answers
643 views

Create my own unity lens [duplicate]

Possible Duplicate: How do I start developing a lens for Unity? Is there any easy way of creating a unity lens without any big programming knowledge? I can code in php, mysql, html and all ...
3
votes
1answer
907 views

Unable to install mysql under Ubuntu 12.04 LTS [duplicate]

Possible Duplicate: How to get MySQL back on Ubuntu 12.04? i'm getting the following error when trying to install MySQL Server under Ubuntu: Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ... ...
2
votes
4answers
2k views

Accessing MYSQL through terminal

I just installed LAMP in my computer through commandline.Now how can I access MYSQL prompt from commandline?I need to use MYSQL to create tables,views and then access them from my Perl script.
2
votes
2answers
5k views

Backup mysql from terminal

I have scheduled a cron job to backup mysql databases on ubuntu9.10. I used the following entries in the cron file. 37 4 * * * root /usr/bin/mysqldump -u root -p<mysql-password> --all-databases ...
2
votes
3answers
19k views

How to stop mysqld process?

result of ps -e | grep mysqld running htop and clicking on memory usage.. It is taking 33% of 4gb memory. I just want to end the mysqld process.. running sudo pkill mysqld ends the process but ...
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: https://www.exratione.com/2012/05/a-...
2
votes
3answers
2k views

What is the easiest, most effective backup system for Ubuntu Servers?

I'm trying to backup my /var/www/ folder, MySQL, and any other special documents like in the /etc/apache2/ folder. Does anyone have any solutions for backup software? Maybe something that's Cronjob-...
2
votes
2answers
446 views

lamp-server wants to install mysql but i want it to use already installed MariaDB

i want to install lamp-server in ubuntu 10.10 (the end goal is to install redmine), i am using sudo tasksel install lamp-server However after downloading packages it asks for a root password for ...
2
votes
2answers
379 views

mysql don't ask for root password when installing

I use apt install mysql-server to install MySQL on Ubuntu 16.04 but during the installation, it does not ask for root password .After installation it had ERROR 1045 when i tried to login as root ,...
2
votes
3answers
33k views

Forbidden You don't have permission to access /phpmyadmin on this server

I installed php, mysql, phpmyadmin on my Ubuntu 12.04 localhost in the following steps: I try these steps: sudo apt-get install apache2 sudo /etc/init.d/apache2 restart sudo apt-get install php5 ...
2
votes
2answers
8k views

Cant see databases of mysql from command prompt in ubuntu 12.04

1) I have installed mysql server and mysql client through apt-get install mysql-server and apt-get install mysql-client 2) when I run sudo netstat -tap | grep mysql, I see following: tcp 0 ...
2
votes
2answers
5k views

Error while installing mysql-server-5.1

I need to install mysql-server-5.1 on ubuntu 11.10. While installing with apt-get I am getting dpkg: error processing mysql-server-5.1 (--configure): subprocess installed post-installation script ...
2
votes
1answer
3k views

How to install mysql DB while offline?

I have downloaded mysql-5.5.9-linux2.6-i686.tar.gz file. I don't know how to install it into my Ubuntu os. I don't have an internet connection, I'm posting here from browsing center. I can download ...
2
votes
1answer
2k views

Installing/configuring mysql server nightmare

I've never had problems installing and configuring mysql server in kubuntu but now it's just being stubborn, here's my issue: I installed the packages mysql-server, mysql-client (both 5.1), the ...
2
votes
2answers
226 views

How to repair corrupt package installation (mysql)

After upgrading to Ubuntu 16.04, I noticed mysql was having mind-boggling errors. Convinced, it was a broken setup, I tried running a purge of mysql. That didn't seem to delete everything, so I tried ...
2
votes
6answers
1k views

can't login as mysql user root from normal user account in ubuntu 16.04

I just installed Ubuntu 16.04 LTS along with the packages php, mariadb and nginx. I ran mysql_secure_installation and changed the root password. Now when I try to login to mysql using the root ...
2
votes
2answers
78 views

Can i put everything back after accidentally doing “apt-get remove mysql-server”?

I have accidentally typed in webserver terminal following command: sudo apt-get remove apache2 php* mysql* -y Can i rescue my database tables, without a backup? I know that, for instance, apache ...
2
votes
2answers
236 views

where to see created mysql database and tables

There is no mysql in /var/lib where I expected to find the databases and tables.
2
votes
2answers
14k views

Trouble Installing MySQL workbench [closed]

I am new to Ubuntu Linux. My Professor asked us to download Ubuntu 10.10. I have made several attempts to download MySQL as 32 and 64 bit in Debian packages and it keeps failing. See below for what i ...
2
votes
1answer
4k views

Installing MySQL complete?

How I can install mysql in ubuntu 12.04(gnome 3). So that I will have my mysql installation in /usr/bin/mysql It's library and header files in /usr/lib/mysql and /usr/include/mysql respectively. ...
2
votes
4answers
8k views

Unable to install mysql 5.6 in ubuntu 12.04

I download mysql-5.6.16-debian6.0-x86_64.deb from official site. Install using dpkg -i mysql-5.6.16-debian6.0-x86_64.deb It does create file in /opt/mysql/server-5.6/. root@ubuntu:~# cd /var/lib/...
2
votes
3answers
449 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?
2
votes
1answer
678 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, /var/lib/juju/mysql....
2
votes
1answer
2k views

Script to enter data from mysql database into text file

I have written a script to extract the contents of a table into a textfile. this is my code #!/bin/bash mysql -uroot -ppasswd database select * from table>textfile.txt i have changed ...
2
votes
1answer
5k views

How to install the mysql connector for C#?

I installed Wine and now I have setup Mono & .NET When I try to compile the next sentence, I get an error because I don't have the MySQL connector installed on my system. using MySql.Data....
2
votes
1answer
624 views

LAMP Stack Location

I have installed the LAMP stack on Ubuntu 12.04 LTS using the tasksel command. I checked - it works. But I cant find the location of the installaton, I worked with WAMP - there you have a separate ...
2
votes
4answers
3k views

Mysqld not starting on boot?

After upgrading to Pangolin, mysqld is not starting on boot. I've looked into various other MySQL issues with the Pangolin release, and I haven't seen the same issue that other people are having (...
2
votes
1answer
6k views

Is multiple mysqld processes for 1 mysql server is normal?

I'm not an server administrator, but i would like to know why on the server i have like 10 myslq instances? Is it good or bad? Does it negatively impact speed of my website? Here's screenshot: ...
2
votes
2answers
1k views

12.04 upgrade stops at 'mysql restarting'

After downloading the upgrade started but the script stopped at 'mysql restarting'. What should I do now? The system doesn't launch any application and doesn't accept any commands. Should I reboot ...
2
votes
3answers
22k views

mysql problem '/var/run/mysqld/mysqld.sock'

I got this error on my php script with db: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and on phpmyadmin: #2002 Cannot log in to the MySQL server What is ...
2
votes
2answers
2k views

MySQL 5.5 PPA Trustworthy?

I found this PPA which features MySQL 5.5 (alongside php 5.3.8 packages..): https://launchpad.net/~nathan-renniewaldock/+archive/ppa Seems to be working fine on my 11.10 Ubuntu, ut I can't find ...
2
votes
3answers
2k views

How do I install MySQL workbench?

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
2
votes
1answer
1k views

Cannot enter phpmyadmin as root (MySQL 5.7)

I'm using Ubuntu desktop 16.04 (upgraded from 15.10). I had installed phpmyadmin from by apt-get install phpmyadmin. It works if I go to localhost/phpmyadmin but I cannot log into it as root. I have ...