New answers tagged

1

If the OOM killer is being invoked, it means your system's physical RAM and swap are both full. No amount of tinkering with /proc or php.ini will fix this. You've got three options: Increase the size of the swap space. Install more RAM. Re-write your program to be more memory-efficient.


0

for Linux out-of-memory (OOM) killer Check dmesg for messages about it


0

Most blank screen on boot issues for me historically have been due to an issue with the nvidia driver or another proprietary driver. Some programs can interact in odd ways that cause the error i.e. wine. If you have nvidia-current installed you may try removing it to isolate the error. Can you get to the Ubuntu login screen or does it go blank before?


1

Sometimes the -f option is not going to work for you. If it doesn't work, then you have to install the package giving an exact version. In order to do so, you can use = to set the version the system wants. For example: sudo apt-get install apache2=2.2.20-1ubuntu1 sudo apt-get install mysql-server=5.5


1

I don't understand, how you got into that situation, but you could update your cache sudo apt-get update and then try to let apt-get resolve the problem: sudo apt-get -f install The -f flag fixes broken dependencies.


0

In my case I could solv the problem by adding # Allow log file access /home/system/var/log/mysql.err rw, /home/system/var/log/mysql.log rw, /home/system/var/log/mysql/ r, /home/system/var/log/mysql/** rw, to /etc/apparmor.d/local/usr.sbin.mysqld For more details take a look at my answer (by ChristophS) at stackoverflow.


1

I had the same problem, and although I don't know how to uninstall akonadi, I uninstalled the applications that make usage of it: kontact, kaddressbook, kmail, knotes and korganizer. Akregator doesn't seem to start akonadi so I let it installed. sudo apt-get remove kontact kaddressbook kmail knotes korganizer My memory usage had decreased from almost ...


0

I get the same symptoms when I update, but for me the fix (after killing mysql and restarting with --skip-grant-tables to get in) is to execute update mysql.user set plugin = ''; The update process likes to set this column to "unix_socket". I don't know what that is supposed to accomplish, but for me it breaks everything.


0

The configuration file name and directory change in Ubuntu 16.04 The new file and location here: /etc/mysql/mysql.conf.d/mysqld.cnf You can edit this using: sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf OR sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf I find this solution here: http://www.cyberciti.biz/faq/howto-install-mysql-on-ubuntu-linux-16-04/


0

the configuration file name and directory change in Ubuntu 16.04 The new file and location here: etc/mysql/mysql.conf.d/mysql.cnf you can edit this using sudo nano mysql.cnf


0

This answer http://askubuntu.com/a/258598/116889 helped me figure out how to do it by downloading the .deb packages from MySQL dev site. The solution about adding the PPA did not do it for me. It links to a blogpost available here: http://www.peterchen.net/2013/02/20/en-how-to-install-mysql-5-6-on-ubuntu-12-04-precise/ Tricky but it works.


1

Apologies for all the edits. I posted from my tab. How do I uninstall Mysql? which provides the following: 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 16.04 is riddled with loads of bugs right now. expect many ...


0

In my case, with strace, I saw that /var/run/mysqld/ didn't exist and mysqld can't create the file mysqld.sock. These commands solved my problem: mkdir /var/run/mysqld chown mysql.mysql /var/run/mysqld chmod 700 /var/run/mysqld Now: systemctl start mysql And mysql works again :)


0

Try apt-get -f install to fix your broken SQL package and if you are still in problem with package manager download SQL server source code and compile it !! But try above command and also use dpkg -l | grep sql to find out package manager still think you SQL or not ..


2

MySQL 5.7 changed the secure model, not allowing MySQL root user login without sudo (while the password can be blank). I.e., phpMyAdmin will be not able to use root as user. The simplest (and safest) solution will be create a new user and grant required privileges. 1. Connect to mysql sudo mysql --user=root mysql 2. Create a user for phpMyAdmin Run ...


0

Until ubuntu provide a fix for this problem, i found a workaround! I use the command pkill -f akonadi and add it to the startup. System Settings>>Startup & Shutdown>>Autostart. using this command all the akonadi services get killed at startup and mysqld process will be killed along with it and all the memory occupied by them will be released. after ...


1

You have two repositories which provide MySQL: the official Ubuntu 14.04 ones provide MySQL 5.5, and the official MySQL ones provide 5.7. This is why you cannot manually install 5.6 packages without some forcing, it would be better to go with either 5.5 or 5.7. In that case you should: Uninstall all residual 5.6 packages, you can find them with dpkg -l | ...


0

PHP7.0 is standard on Ubuntu 16+ Heres the rundown: 1 As Always sudo apt-get update 2 Install Apache2 sudo apt-get install apache2 3 Install mysql-server sudo apt-get install mysql-server 4 Install PHP 7.0 sudo apt-get install php7.0 libapache2-mod-php7.0 php7.0-mysql php7.0-curl php-mbstring php7.0-mbstring php-gettext php7.0-json php-xml ...


2

Today I got the same problem, after trying many solutions i found that the problem was the command sudo systemctl disable mysql.service that i used to disable MySQL auto starting, so to get it working i re-enabled again MySQL server using the command sudo systemctl enable mysql.service and run again the upgrade process and it terminated perfectly.


7

The instructions @andrew-beerman posted are on the right track, though they aren't quite clear to me and seem to recommend more than is necessary. I pieced together the answer from the above and a helpful post in the bug thread. These are the steps I took to correct this: Back up your my.cnf file in /etc/mysql and remove it Remove the folder ...


0

Looks that I managed to do it. Here's what I did: In Software & Updates / Other Software added 14.04 repository: deb http://archive.ubuntu.com/ubuntu trusty main Installed mysql client and server: sudo apt install mysql-server-5.6 sudo apt install mysql-client-5.6 Update: Before installing 5.6, make sure that no other mysql packages are present: ...


0

I have played around a bit and was able to fix this problem ... I used This Tutorial to fix the issue. Once I added the things it mentioned and made sure the permissions were correct I was able to change settings without an error.


5

The instructions here fixed it on my server: https://bugs.mysql.com/bug.php?id=72722 I can understand the pain of having your system in inconsistent state but lets not worry about the whole situation and take it step by step to get the system clean. First lets see the current state of all the mysql packages on machine using: dpkg -l | grep ...


1

Some packages can't be uninstalled if some dependencies are gone, or some configuration files have been deleted for some reason. You will end up with a package that is not completely installed nor completely uninstalled. The solution, in this case, is to sudo apt-get install the package. If necessary, do sudo apt-get install --reinstall [package]. Missing ...


1

I have a similar problem. I tried to use MariaDB 10.0 with MySQL Workbench, and the were some issues, the point is that I end up installing and uninstalling MySQL and MariaDB packages until I broke all and I could not install either MariaDB or MySQL.I had a bad time trying to solve it and finally I found a solution, I made it from similar questions related ...


0

The screenshots are showing a server with modest RAM, but apparently OK as you aren't using swap space even on the 10 hour one, and it's usually swap that kills a computer's speed if it's a memory problem. I think you need to run & monitor top to see if it varies much & uses swap space when it is slow, also to see if there's a CPU hog. I use a ...


0

First to check your hardware. Run MemTest86 at least 24 hours to make sure your memory is not root cause. Due to sendmail-mta hangs, my experience is due to DNS issue (by gethostent) or YP/NIS issue (if you have installed nis). Try this command to see whether you have installed nis. dpkg -l nis If yes, try to remove it by apt-get remove nis if you ...


1

I lost hours to solve this problem. Just install php-mbstring, php7.0-mbstring and php-gettext. That's it. You can do that by running the following command: sudo apt-get install php-mbstring php7.0-mbstring php-gettext


1

Python is not related to any of the lamp packages. So no, they shouldn't conflict with each other. P.S. If you do not need the full LAMP stack, you don't have to install all of its packages. For example, if you need to install just PHP Apache, you can do that by running sudo apt-get install php5 If you need both Apache and PHP, then you would run sudo ...


0

Install gdebi, it lets you install local deb packages resolving and installing its dependencies. apt-get install gdebi After that install your MySQL .deb package with gdebi gdebi package.deb


0

You can run this command that should fix package dependencies: sudo apt-get install -f and then run the installation command sudo dpkg -i mysql-workbench-community-6.3.6-1ubu1510-amd64.deb (I'm supposing you downloaded .deb file from mysql website, you're running Ubuntu 15.10 and your terminal is in the same directory of mysql workbench installation ...


0

For the latter viewers: I came to the similar error when I failed to upgrade mysql-server package, but I found this solved my problem. When sudo apt-get install -f doesn't work, try sudo apt-get purge mysql*. Now you can reinstall mysql-server.


1

The phpinfo() function shows the version of the libmysqlclient.so library that's linked to mysql.so PHP extension. You can check that by switching to php5-mysqlnd package that uses PHP MySQL native driver without linking to libmysqlclient.so. You can confirm this by checking the version of libmysqlclient library on your system: dpkg -l 'libmysqlclient*' or ...


0

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) the error occur when mysql service not start. no need to remove mysql. please follow mentioned below steps: $ sudo su /etc/init.d/mysql start


3

You need to install php-gettext , Install it using sudo apt-get install php-gettext


0

The installation process will not ask you for the root password nor for your personal user password but for the password of the database user root. This is, if you dont changed it, initaly empty. You should run mysql_secure_installation and set a mysql root password when asked for it. Then restart installation of phpmyadmin with the now well known mysql ...


3

Try: sudo service mysql stop then: sudo apt-get purge mysql-server sudo apt-get autoremove less /etc/passwd Check right at the bottom if there is a mysql user. If there is: sudo userdel mysql After all this is done, try to install Mysql again using the command you used previously.


0

Your problem is thread_pool_size. If it's much higher than the number of cores/threads, you'll not be able to shutdown properly unless by using mysqladmin shutdown command. Eg.: You have 2 cores CPU with 4 threads. If you set it 1-4 - it will work fine. If you set it to 16, as advised in many 'high performance' blogs, it'll get pooched.


0

Open phpMyAdmin>config.inc.php in your favourite text editor. Search for: $cfg['Servers'][$i]['auth_type'] = 'config'; Replace it with: $cfg['Servers'][$i]['auth_type'] = 'cookie'; cookie ;) "essa eu garantio"


1

This problem happens because .mysql was created by root user using sudo and the permissions are to only read for others that are not the owner.. To simply fix this issue, change the owner of the folder to the desired user using this command in terminal: sudo chown -R <user>:<group> .mysql what this command does? i will explain each one of ...


0

Reinstall it using the cmd on terminal sudo apt-get purge mysql-server-5.6 then sudo apt-get install mysql-server-5.6


0

I fixed this by changing bind-address 127.0.0.1 to bind-address 0.0.0.0 in /etc/mysql/mysql.conf.d (so that MySQL listens on all ports). Also, I set up a mysql user account to be used remotely (see http://stackoverflow.com/a/24171107/132374).


0

sudo apt-get install python3-mysql.connector this will install mysql.connector for python3 on ubuntu


1

Go to MySQL Community Server (Archived Versions) download site Choose Select Version: 5.6.19 Choose Select Platform: Ubuntu Linux Download the mysql-server_5.6.19-1ubuntu14.04_*.deb-bundle.tar for your architecture Untar tar -xvf mysql-server_5.6.19-1ubuntu14.04_*.deb-bundle.tar Follow the detailed instructions for installing and configuring individual ...


0

another possibly fix is to use the following in [mysqld] section of your /etc/mysql/my.cnf configuration. performance_schema = off Source: http://serverfault.com/questions/564748/mysql-mariadb-crashes-frequently


1

apparmor was the culprit. Despite the contents of /etc/apparmor.d/usr.sbin.mysqld being nothing but comments and claiming that it was there so that apparmor wouldn't choke on MariaDB, that's exactly what was happening. AppArmor and MySQL on an Oracle blog provided what I needed to figure out what was going on. sudo aa-status shows you what apparmor is ...


0

First use this command in shell (Ubuntu): ubuntu@ubuntu-PowerEdge-2850:~$ sudo /opt/lampp/lampp startmysql Second use this command in shell (Ubuntu): ubuntu@ubuntu-PowerEdge-2850:~$ /opt/lampp/bin/mysql -u root -p database < "/opt/lampp/htdocs/database.sql" Enter password: (Press Enter)


0

Additionally, did you install the MySQL connector/NET? http://www.mono-project.com/docs/database-access/providers/mysql/ Download link: http://dev.mysql.com/downloads/connector/net/ Good luck!


0

What a hideous sidebar, hahaha, I'm sorry. The problem is that the MySQL client in your C# program cannot connect to the MySQL server. Are you able to log into the MySQL server yourself? You may be connecting from another machine with a user that is only locally available. Please check the permissions/credentials of the user you're trying to log in to ...



Top 50 recent answers are included