[Fixed] Cannot load from mysql.proc. The table is probably corrupted

Something spoopy was going on in my database. All was working fine, but it kept spewing out the following error:

Cannot load from mysql.proc. The table is probably corrupted

So this was fixed by going into the database terminal and entering:

mysql_upgrade -u root -p

Make sure you have the root/privileged password ready. Depending on how many databases you have and how large they are; it can take a bit of time. Have patience.

Loading

Brutally brief: Create a new database and or user in MYSQL

Log in:

mysql -u root -p

Create a user:

create user 'newuser'@'localhost' IDENTIFIED BY 'password';

Give them all the power:

grant all privileges on * . * TO 'newuser'@'localhost';

Reload privileges:

flush privileges;

Ditch a user: (Optional)

drop user 'newuser'@'localhost';

Log out:

\q

—————-

Log in:

mysql -u newuser -p

Create a database for the user:

create database db_name;

List databases: (Optional)

show databases;

Ditch database: (Optional)

drop database db_name;

Log out:

\q

Done.

Loading

Unusual balance differences in Invoice Ninja

Probably caused by utilizing the wrong method in an older version, where one had to manually enter the paid amount instead of selecting “mark invoice paid”

Step 1. Check the affected clients and make sure that the actual paid sum is correct, regardless what the “minus” amount says.

Step 2. Make a backup, or find a proper host where you can do an easy roll-back in case you mess up.

Step 3. Open the database of Invoice Ninja and find the “clients” table

Step 4. In the column “Balance” you will see a negative amount. Double-click in that field, enter 0.00 (zero-point-zero-zero) and press enter.

Done

Loading

How to reset Joomla (admin) passwords in MySQL

Oh joy, you lost the admin password. Now what?

If the admin user is still defined, the simplest option is to change the password in the database to a known value. This requires that you have access to the MySQL database using phpMyAdmin.

“what, no hacking?”, I hear you say. No. Again, you need access to the MySQL database by using phpMyAdmin.

  1. Navigate to phpMyAdmin and select the database for the Joomla site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  2. Click on the table “jos_users” in the list of tables.
  3. Click on the “Browse” button in the top toolbar.
  4. Find the user whose password you want to change and press the Edit icon for this row. A form will display that allows you to edit the password field.
  5. Copy the following value into the password field and press the Go button.
    d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
    
  6. At this point, the password should be changed to “secret”.
  7. Log in with this user and password and change the password of this user to a secure value.

Loading