Hot answers tagged

6

You can recover or set root password without knowing the current one by starting mysql without loading the grant-tables. This is the cli to do this: $ sudo mysqld_safe --skip-grant-tables Now you can log in as root without a password and perform all commands, as in this case, set the root password as root. $ sudo mysql --user=root mysql This is the ...


3

Thanks to @Videonauth sudo dpkg -r mysql-client-5.7 sudo dpkg -r mysql-server-5.7 sudo dpkg -r libmysqlclient20:i386 sudo dpkg -r libmysqlclient20:amd64 sudo dpkg -r libmysqlclient18:amd64 sudo dpkg -r mysql-common Then running: sudo apt-get purge mysql-workbench mysql-server mysql-common mysql-client If anything fails, just run sudo dpkg -r ...


2

It seems that the question is not about the category "GUI clients that make writing SQL statements easier", but "clients that avoid SQL or generate it for you". So, relevant products would have wizards, or query builders, or table builders, or QBE. phpMyAdmin has already been excluded, and MySQL Workbench has already been mentioned. Non-WINE ...


2

I have encounter the same problem. Though i had the big enough memory 12Gb given to my VM, but still things were failing as in question. After spending some time found that default apt get was missing some of the configuration translation and tool translation packages. The MySQL apt repository provides a simple and convenient way to install and update MySQL ...


2

This is pretty normal for applications like Xampp, MySQL, etc. Unless you install it in the home directory, it is usually installed in places like /opt/, which usually needs sudo access to run (unless you forceably disable that with the chmod command) to run as user http://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html


2

Do the following to clean out the broken packages: sudo apt-get clean sudo apt-get update sudo dpkg -r mysql-client-5.7 sudo dpkg -r mysql-server-5.7 sudo dpkg -r libmysqlclient20:i386 sudo dpkg -r libmysqlclient20:amd64 sudo dpkg -r libmysqlclient18:amd64 sudo dpkg -r mysql-common sudo dpkg -r mysql After that reinstall it with: sudo apt-get install ...


2

Can you paste all output from an apt-get update? Maybe if you try this: sudo rm -f /var/cache/apt/archives/mysql* sudo apt-get autoclean Then: sudo apt-get update


2

To remove mysql completely from your system run following command in terminal sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-5.5 mysql-client-core-5.5 sudo rm -rf /etc/mysql /var/lib/mysql sudo apt-get autoremove sudo apt-get autoclean Hope it helps.


1

rc mysql-server-5.5 means, that the package is uninstalled (r), but some configuration files remain (c) (in case you want to install it again later). In order to remove them (and make the package disappear from dpkg -l altogether), use sudo apt-get purge mysql-server-5.5.


1

That error number suggests that you have something in your 'mysql' database (the one it uses for settings) that is incompatible with this version of mysql. The plugin could not be loaded to handle that bit of data and that is preventing mysql from loading. I'm guessing its a maria db thing that is not supported in mysql. One way round this would be to ...


1

Open a terminal and type: sudo apt-get remove --purge phpmyadmin or as Rinzwind noted sudo apt-get purge phpmyadmin this should (1) remove phpmyadmin and (2) remove its settings files and so on too.


1

Edit: upon re-reading your question I surmise that your server is behind a firewall that you do not control? If so, please disregard the iptables part of the answer and skip to the SSH config part... Is it a matter of wanting the transport to be encrypted, or is it simply a matter of getting through the firewall? Getting through the firewall could be as ...


1

You are entirely able to kill the process, but it seems to be starting itself again. If you notice, the PID is changing each time that you kill it. Something on your system is automatically starting it on your behalf. You have a couple of options: Seek and destroy whatever is starting it (usually some sort of web control panel like XAMPP, probably in this ...


1

Moving a MySQL database involves "exporting" it and then "importing" it, not copying it. You have identified that you have "phpmyadmin" installed. On your Windows computer use it to export your database. Copy the resulting file to your Ubuntu computer and use "phpmyadmin" on your Ubuntu computer, in this case, to import it. Alternatively use: mysqldump


1

You do not need to change the root user. For purpose of data operations we usually create a new mysql user and grant certain privileges to this user (generally limited to a database). This can be done in following ways: From terminal mysql -u root -p and enter the root password. Then, in the terminal you will see as mysql> indicating you are ...


1

you shouldn't need the []'s try mysqldump -u root -p guru99 > guru99.sql and guru99 should be your database name


1

The answer is in the comments, but I think It is worth to post it there. I downloaded mysql-apt-config_0.7.2-1_all.deb (MySQL APT repository - dev.mysql.com/downloads/repo/apt) from dev.mysql.com and during config I have chosen Ubuntu Wily since 16.04 was not on the list. And that was the problem, Xenial already has MySQL 5.7 in its official repositories. ...


1

Here is what we have so far. First, edit your /etc/apt/sources.list file and remove mariadb by executing the following commands: sudo sed -i 's/^.*mariadb.*$//g' /etc/apt/sources.list sudo apt-get update Now, let's fix that broken package: sudo apt-get install libmysqlclient18=5.5.49-0ubuntu0.14.04.1 libmysqlclient-dev Please post any more errors, ...


1

libmysqlclient_r.so is not part of the libmysqlclient in ubuntu 16.04. You can create a symlink to the compatible libmysqlclient.so before you run your command using: sudo ln -s /usr/lib/x86_64-linux-gnu/libmysqlclient.so /usr/lib/x86_64-linux-gnu/libmysqlclient_r.so


1

The following commands worked for me to uninstall and reinstall MySQL (in this order, although I don't know if some of these commands are surplus): sudo apt-get install mysql-client sudo apt-get install mysql-server sudo apt-get purge dbconfig-mysql sudo apt-get purge mysql-common sudo apt-get install mysql-server sudo apt-get install mysql-client


1

Ubuntu 16.04 includes PHP 7.0 that doesn't have old MySQL extension anymore as it has been deprecated for some time and removed in PHP 7.0. You either need to update your application to support MySQLi or pdo_mysql or install PHP 5.6 from PPA (ppa:ondrej/php). As for the reinstallation problem, I would suggest removing MySQL packages first and then ...


1

use this option sudo apt-get -f install



Only top voted, non community-wiki answers of a minimum length are eligible