Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
0answers
22 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
54 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
94 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
245 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: ...
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 ...
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 ...
3
votes
0answers
578 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
424 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 ...
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
18k 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: ...
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 ...
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
172 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
2answers
233 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
3answers
31k 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
105 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
2answers
76 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
3k views

Ubuntu 15.10 mysql error 1524 - unix_socket

On Ubuntu 15.10, at a point (maybe after an install & remove of mariadb) mysql was unable to operate. Tasks are up, but the server is down. At the command: mysql -u root -p the system reply ...
2
votes
2answers
13k 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
656 views

akonadi services and mysqld use too much memory in kubuntu 16.04

I recently installed kubuntu 16.04 on my Dell studio xps 1640 that has 8GB of Memory installed. Everything is working fine but Something is really bothering me. After a fresh boot up, when i check the ...
2
votes
4answers
7k 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 ...
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?
2
votes
1answer
659 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, ...
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 ...
2
votes
1answer
615 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
21k 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
2answers
137 views

auto_increment_increment resets after mysql restart? [closed]

I am setting the MySQL variable auto_increment_increment using the following command. mysql -u root -p -e "SET GLOBAL auto_increment_increment = 10;" And it all works, until I restart MySQL (using ...
2
votes
3answers
107 views

How to recover mysql password?

What I had already performed are: sudo /etc/init.d/mysql stop /usr/sbin/mysqld --skip-grant-tables --skip-networking & After this I am getting: [Warning] Using unique option prefix key_buffer ...
2
votes
1answer
152 views

mysql and do-release-upgrade

Could someone tell me what happens to mysql databases when you run a do-release-upgrade? When I do the dry run for do-release-upgrade I see that it will uninstall mysql client and server and install ...
2
votes
1answer
220 views

MySQL upgrade stuck at version selection

I am trying to upgrade my packages on Ubuntu 14.04 , Then MySQL is asking me to choose the server's version that I want to receive , I am stuck there , can't select any option [Including none] Tried ...
2
votes
2answers
147 views

How do I check services requiring a restart (of services, not the machine) by installing updates to other packages

If I run sudo apt-get upgrade then I get shown a list of packages and if any of these are services, they may need to be restarted (which is done automatically when installing the updates). How can I ...
2
votes
2answers
6k views

What does mysql -u root -p mean while logging in?

I am new to using Mysql and I do not understand what does -u and -p imply?
2
votes
1answer
2k views

How to install MySQL DB 5.6.12 (downloaded from mysql.com) on Xubuntu (kubuntu-desktop) 13.04?

I have an experience of setting up and running MySQL on Windows. It is really easy. I just downloaded .zip, unpacked it in C:\MySQL, placed C:\MySQL\bin to PATH and then ran the server with the ...