Dev {Tricks}

You are here: Home / Archives for Server and Hosting

by

Moving mysql database to another user | DirectAdmin

  • Moving a database to a different user

To move a database from one user, to another user,  run the following command:

VERBOSE=1 DBUSER="da_admin" DBPASS="da_adminpass" USERNAME="username" NEWUSERNAME="newusername" /usr/local/bin/php /usr/local/directadmin/scripts/change_database_username.php
  • Replace all bold text with the appropriate info.
  • Ggrab the da_adminpass from /usr/local/directadmin/conf/mysql.conf

 

by

No response from subprocess (php)

Problem:

  • 500 Internal Server Error
  • No response from subprocess (php): The subprocess reported error number 72,057,594,037,927,935 when it ended. The process dumped a core file.

Solution:

Your disk may be full. Free up space as required.

by

Laragon – Powerful universal development environment

Laragon provides powerful tools for Apache, Nginx, MariaDB, MongoDB, PHP, Node.js, Redis, Memcached, npm, yarn, git. It has three different editions – Full, Lite and Portable.

Download laragon at https://laragon.org/download/

Laragon GitHub at https://github.com/leokhoa/laragon/releases/

Important Tutorials

How to install

Just download the latest version To start the journey with Laragon and then click Next, Next, Next…very easy!

Migrate to Laragon

Migrate from WAMP

Migrate from XAMPP

Migrate from others

 

by

XAMPP Error: MySQL shutdown unexpectedly.

Problems:

  • [mysql] Error: MySQL shutdown unexpectedly.
  • [mysql] This may be due to a blocked port, missing dependencies,
  • [mysql] improper privileges, a crash, or a shutdown by another method.
  • [mysql] Press the Logs button to view error logs and check
  • [mysql] the Windows Event Viewer for more clues
  • [mysql] If you need more help, copy and post this
  • [mysql] entire log window on the forums

Solution:

  1. Go to your xampp folder
  2. Then go to mysql/data/
  3. Delete ibdata1 or you may rename it to ibdata1.bak
  4. Start MySQL

It should fix it.