Changing the charset for a MySQL database

Let us say that you have created a MySQL database with the default charset. If you realize that you need to now store non-English characters, say Telugu or Hindi characters into the database, you can change to charset associated with the database to make this happen. Run the following commands. ALTER DATABASE <database name> CHARACTER

What to fix if routes are returning 404 in a Laravel project

Although all the file / folder permissions appear to be set appropriately and if you are having issues with the routes, try the following. Enable mod_rewrite on the apache server using the following command sudo a2enmod rewrite Edit¬†/etc/apache2/apache2.conf, changing the “AllowOverride” directive for the /var/www directory (which is my main document root): AllowOverride All Restart

MySQL root password after installation

If you are wondering what the root password of MySQL is, here are the steps which will help you reset the same. $ sudo apt install mysql-server $ sudo cat /etc/mysql/debian.cnf Note the lines which read: user = debian-sys-maint password = <SomePassword> $ mysql -u debian-sys-maint -p Enter password:  (Enter password <SomePassword> from above here)