Showing entries 1 to 2
Displaying posts with tag: MySQL DBA Techniques (reset)
Dec
09
2015
Fedora LAMP Steps
Posted by Michael McLaughlin on Wed 09 Dec 2015 16:44 UTC
Tags:

I posted earlier in the year how to configure a Fedora instance to test PHP code on a local VM. However, I’ve got a few questions on how to find those posts. Here’s a consolidation with links on those steps:

  1. Go to this blog post and install the httpd and php libraries with the yum installer.
  2. In the same blog post as step 1 (you can put the sample PHP code into the /var/www/html directory for testing), connect to the yum shell and remove the php-mysql library and then install the mysqlnd library.
  3. Go to this blog …
[Read more]
Dec
27
2014
Querying InnoDB Tables
Posted by Michael McLaughlin on Sat 27 Dec 2014 08:18 UTC
Tags:

Somebody ran into the following error message trying to query the innodb_sys_foreign and innodb_sys_foreign_cols tables from the information_schema database: 

ERROR 1227 (42000): Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

It’s easy to fix the error, except you must grant the PROCESS privilege. It’s a global privilege and it should only be granted to super users. You grant the privilege global PROCESS privilege to the student user with the following command: 

GRANT PROCESS ON *.* TO student;

Then, you can run this query to resolve foreign keys to their referenced primary key column values: 

SELECT   SUBSTRING_INDEX(f.id,'/',-1) AS …
[Read more]
Showing entries 1 to 2