New answers tagged

0

I don't know if you have been trying to install Xampp for windows or Lamp for your version of Linux. Maybe this is because of your hurry in asking your question or my insufficient amount of English knowledge. Anyhow if I've comprehended your question correctly, you are trying to install Lamp without having errors in Linux. Linux systems come completely ...


1

we were also facing same issue after Upgarde from 14.04 to 16.04 Solved the problem by removing myisam-recover = BACKUP and key_buffer = 16M from my.cnf Then use "sudo service mysql start" to start the MySQL daemon again and "sudo apt-get -f install" to recover your system packaging state. here I found it https://bugs.launchpad.net/ubuntu/+source/mysql-5....


0

I had the same kind of problem. I had to log in with another session, to kill the dpkg process and to rerun dpkg --configure -a twice before it worked again. Please backup your database if you can before doing the configuration, to make sure you don't lose anything!


1

1st make a mysqldump of all your databases (including information_schema). Then "stop" mysql" and this will remove anything related to mysql: sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-5.7 mysql-client-core-5.7 sudo rm -rf /etc/mysql /var/lib/mysql sudo apt-get autoremove sudo apt-get autoclean and then sudo apt-get ...


0

I checked my /etc/mysql/ folder and found it to be completely empty other than an empty sub-folder conf.d. cd /etc/ # you need to delete the empty mysql folder otherwise the ln below creates the link inside the existing mysql folder sudo rm -r mysql sudo ln -s ./mysql.bak/ mysql then (courtesy of this link this link) sudo dpkg --configure -a and now ...


0

I solved this by commenting out a few lines for safe mode in /etc/mysql/my.cnf $sudo vi /etc/mysql/my.cnf [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0


0

I have a script for this task: lampi Usage: sudo lampi -i -s -n example.com.local -dr ~/example-site What does it do: Install the LAMP stack (-i flag) Setup and configure apache2, mysql, php, phpmyadmin Then set up a custom site named example.com.local (-n option) Set ~/example-site directory as it's document root (-dr option) Enable SSL (https) for ...


1

This is fixed in MySQL 5.7.13 (see Bug 80772): https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-13.html#mysqld-5-7-13-bug This fixed it for me. At the moment the highest version available through apt is 5.7.12 so to get 5.7.13 you can use one of the options here: https://dev.mysql.com/downloads/mysql/ Take your time though. I used the MySQL PPA to ...


1

It should be as simple as making a copy of the file. Then, if something goes wrong, you can just delete your modified file and rename the copy. I would do: sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak then: sudo nano /etc/mysql/my.cnf To restore: sudo rm /etc/mysql/my.cnf sudo mv /etc/mysql/my.cnf.bak /etc/mysql/my.cnf


2

It's a normal file so you can cp top create a backup sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.backup and restore it sudo cp /etc/mysql/my.cnf.backup /etc/mysql/my.cnf You may use whatever file name and path you want instead of /etc/mysql/my.cnf.backup


1

I had the same problem with mysqldump 5.7.13 in a script launched by crontab. You can set the .mylogin.cnf file location using the MYSQL_TEST_LOGIN_FILE environment variable before calling the mysqldump command : export MYSQL_TEST_LOGIN_FILE=/root/.mylogin.cnf mysqldump --login-path=mysqldump [...]


1

Completely disabling IPv6 is getting harder and harder these days. In many operating systems and for many applications it's a crucial component now. if you really want to remove all traces of IPv6 then your only option might be to recompile a lot of software with different options. I think the best option In most cases is to leave it enabled and configure ...


0

According to this site, you need to edit some configuration and run a few commands to complete the setup. Add the following to /etc/apparmor.d/usr.sbin.mysqld: /NEWSQLPATH/ r, /NEWSQLPATH/** rwk, Then run: sudo apparmor_parser -r /etc/apparmor.d/usr.sbin.mysqld sudo /etc/init.d/apparmor reload You can also add this to /etc/apparmor.d/tunables/alias: ...


0

Run: xtrabackup --backup --target-dir=/path/to/targetdir --datadir=/var/lib/mysql/ You may need to install it with: sudo apt-get install xtrabackup


0

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User = 'root' before the "ALTER USER ..." command which sets the password, then flush privileges.


0

I saw this Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. invoke-rc.d: initscript mysql, action "start" failed. as a clue that there was still an erroneous start-up script in existence. Look for /etc/init.d/mysql and any symlinks to it. Removing ...


0

Here is the different link that can help you (thank you to Jos and the people who answer this different topic) Using the proper command to restart MysQL Editing your innoDB Files Careful to the Flush command, it might generate error (was the case for me, maybe it was because i didn't do the last step properly) How to make the change works and not crash ...


0

Increasing the available RAM by adding new Swap space might also help. Steps are here Make sure that you create /swapfile of the size smaller than the available space shown by df -h For example for me output of df- h was: Filesystem Size Used Avail Use% Mounted on /dev/xvda1 7.8G 1.2G 6.3G 16% / none 4.0K 0 4.0K 0% /sys/...


0

Yes, that would be the easiest. Just dump the databases using mysqldump and use mysql command line to import the databases. If there are any problems (like an invalid definer) you will get a notice and can fix it by editing the dump.


-1

You are missing the php7.0-mysql package. So you should install the php7.0-mysql package. PS: Why are you downvoting this? It has solved OP's problem.


1

For remote access: Check etc\mysql\my.cnf to see that the bind-address is not set to 127.0.0.1. Either set it to 0.0.0.0, or, to be more secure, add your IP address: bind-address = 127.0.0.1 bind-address = your_public_ip Create a user in the mysql table: CREATE USER 'non-root-user'@'localhost' IDENTIFIED BY 'any_password_u_like'; CREATE USER '...


1

Installation of the MySQL server involves roughly three steps: 1) unpacking the software; 2) creating a default database; 3) creating a default user/password (and storing this in the database). Should you accidentally lose the database files (usually located in /var/lib/mysql) then you can start again without completely reinstalling the server package. ...


2

I downloaded the mysql-server-5.7 package to test: $ apt-get download 'mysql-server*' Get:1 http://mirror.cse.iitk.ac.in/ubuntu xenial-security/main amd64 mysql-server all 5.7.12-0ubuntu1 [10.1 kB] Get:2 http://mirror.cse.iitk.ac.in/ubuntu xenial-security/main amd64 mysql-server-5.7 amd64 5.7.12-0ubuntu1 [2,584 kB] Get:3 http://mirror.cse.iitk.ac.in/ubuntu ...


1

You can certainly disable apache and MySQL services on boot. They won't make a huge difference, but unless you are using them, they don't necessarily need to be running. Also, disabling virtualbox should not cause any errors.


0

if you are running XAMPP on 14.04 this must work sudo chmod 644 /opt/lampp/phpmyadmin/config.inc.php


0

Finally I have been able to solve my problem. In terminal you have to type: systemctl start mysql.service systemctl enable mysql.service /usr/bin/mysql_secure_installation That's it all done


2

I found the problem. I had replaced the default php.ini file with one from a different server, and that must have messed it up. I reinstalled LAMP & phpmyadmin, this time leaving php.ini alone, and it worked just fine.


0

Run sudo apt-get install phpmyadmin php-mbstring php-gettext sudo service apache2 restart http://www.dailytechnoblog.com/how-to-resolve-phpmyadmin-error-the-mbstring-extension-is-missing-please-check-your-php-configuration/


0

Edit the akonadi server configuration file at ~/.config/akonadi/akonadiserverrc. Change StartServer=true to StartServer=false.


4

I recently upgrade my Ubuntu 15.04 to 16.04 and this has worked for me: 1 - First, connect in sudo mysql sudo mysql -u root 2 - Check your accounts present in your db SELECT User,Host FROM mysql.user; +------------------+-----------+ | User | Host | +------------------+-----------+ | admin | localhost | | debian-sys-maint | ...


0

I got same issue when I followed following tutorial to install mysql 5.6 on ubuntu 14. I had installed Ubuntu using vagrant. I had assigned only 512 MB to the virtual machine. To fix it I did following things. 1) Increased the virtual machine Memory to 1024MB config.vm.provider "virtualbox" do |vb| # # Display the VirtualBox GUI when booting the ...


0

This problem is solved, but it took multiple times to fix. The first command after login must be sudo dpkg --configure -a and it doesn't due the stop/waiting during setup of the update. It must of been an issue with the previous version of mysql but here's the answer for anyone else experiencing this problem.


0

Upgrading to Ubuntu 16.04 updates automatically you php to php7 version , you are just missing php7-pdo extension sudo apt-get install php7-pdo then restart your web server should fix your issues.


1

Run the following commands: mkdir MYSQL cd MYSQL sudo apt-get download mysql-common ar xvf mysql* tar xvf dat* sudo cp ./etc/mysql/my.cnf.fallback /etc/mysql/my.cnf.fallback sudo dpkg -i mysql*deb cd sudo apt-get -f isntall


0

if the user with the password can login locally but cannot remotely due to Access denied for user 'user'@'his_ip' then GRANT ALL ON dbname.* TO 'user'@'his_ip'; If he can't even connect then check firewall and if mysql listen that interface: netstat -plnt | grep 3306


0

The problem was in the beginning, My php version is 7 and php7 compatible joomla versions are 3.5 and laters that's why I was having these problems. So I just loaded the joomla 3.5.1 version and bingo. I discovered this in here https://docs.joomla.org/J3.x:Installing_Joomla in the references section.


0

Pretty easy and simple step could be a solution: Execution Time Limit needs to be set as 0 in config.default.php file. Which looks like $cfg['ExecTimeLimit'] = 300; Make it to $cfg['ExecTimeLimit'] = 0; Location of that file supposed to be at /usr/share/phpmyadmin/libraries Ref:Script timeout passed, if you want to finish import, please resubmit same ...


1

It looks like there's something wrong with your PHP version. Try this: # sudo apt-get update # sudo apt-get install php7.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7


0

Run the following commands: sudo apt-get update sudo mkdir /etc/mysql/conf.d sudo apt-get -f install Then, I seriously suggest you update your software before doing anything else. Run one of the following commands: sudo apt-get upgrade or, recommended: sudo apt-get dist-upgrade Click here if you don't know the difference.


2

Instead of XAMPP you may use LAMP(Linux Apache MySQL PHP) mostly. Using LAMP you may also face this problem. In my case(using Ubuntu 15.10), I had configured/set post_max_size, upload_max_filesize, max_execution_time, max_input_time, memory_limit following my needs using php.ini file which is located at /etc/php5/apache2/php.ini But still I was faced this ...



Top 50 recent answers are included