Ah, my problem ended up stemming from an issue with php5-fpm. Essentially, there were php5-fpm services running that were “old” and thus when I tried to access mysql from the web, it wasn’t detected. But when I tried to access it via cli, it was detected. That narrowed it down to php5-fpm for me, and then I had to do:
sudo killall php5-fpm
sudo service php5-fpm start
And voila, the web side started recognizing mysql just fine!
I’m still not sure what exactly led to a php-fpm process that the service wasn’t aware of to restart, but it’s something to watch out for.
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- SQL – Update multiple records in one query
- When to use SELECT … FOR UPDATE?
- ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
- Database sharding vs partitioning
- Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
- Search for all occurrences of a string in a mysql database
- how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
- #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
- How to convert a string to date in MySQL?
- MySQL COUNT DISTINCT
- How to update a record using sequelize for node?
- Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
- Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
- Convert MySQL to SQlite [closed]
- Create a temporary table in a SELECT statement without a separate CREATE TABLE
- Convert partially non-numeric text into number in MySQL query
- MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
- Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
- MySQL: What’s the difference between float and double?
- How can I search (case-insensitive) in a column using LIKE wildcard?
- MySQL Select Multiple VALUES
- How to do a batch insert in MySQL
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- How to unblock with mysqladmin flush hosts
- Node.js MySQL – Error: connect ECONNREFUSED
- Solution to “subquery returns more than 1 row” error
- MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
- How To have Dynamic SQL in MySQL Stored Procedure
- MySQL – UPDATE query with LIMIT
- MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
- What SQL Query to do a simple find and replace
- Scanning Database for malicious Data
- how to refresh wordpress permalink settings? (without admin panel)
- Ordering posts by day (not time) AND meta value
- wpdb->prepare function remove single quote for %s in SQL statment
- Problems with DBDelta with FOREIGN key?
- Is it useful to turn on MySQL query cache for performance
- Programmatically changing role information; editing role name and deleting
- Same option_id=0 for 2 options in wp_options?
- How to let a user choose an authors and save it to the database?
- Search and replace in post content
- How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
- wpdb insert and boolean fields
- MySQL crashed because of the large number of requests
- What are the issues associated with upgrading MySQL for WordPress?
- How to find meta entries with their posts missing via SQL?
- Mysql SELECT posts
- How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
- Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
- SQL Database, repeated tables?
- Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
- Alter wp_post table vs. post_meta performance/speed
- Code to remove authors with no posts connected to them
- SQL Query in WordPress – Getting Impossible WHERE error
- WordPress create database not working
- Import CSV to MySQL, with custom registration field information
- database optimization and server errors
- Update Custom Post Type Taxonomies with SQL
- Setting up WordPress Locally on WAMP for a new site (with one already)
- Remote database -> massive response time increase?
- Calling mysql_query() on another database, assumes WordPress using that database
- WordPress VIP realpath Alternative?
- querying user bookmarks from a large number of bookmarks
- Pull post name from value of a specific meta key
- PHP variables in mysql query
- How to fix the amount of comments displayed for each post?
- How do I echo all users’ display_name and their meta_value who have a certain meta_key?
- Lock wait timeout exceeded; try restarting transaction
- How to simulate web traffic to test performance of a website
- SQL query to change custom field in WordPress database
- SQL. Select category descendants
- What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
- MySQL Actibity without any active visitors via Google Analytics
- How to configure WordPress Database for CentOS 7
- Why is local wordpress install calling live site executions?
- Add row to SQL array
- Display MySQL as part of a Page
- Migration of wordpress database from mariadb 10.0.20 to 5.5.50
- Use custom query if main search query returns zero results in wordpress
- WP Meta Query – mixed AND / OR query doesn’t work
- Can I use mysql queries to replace query_posts()?
- Second completely independent and disposable WordPress installation in subdirectory?
- get_results suddenly not working on a single table
- Internal error (500) on local & Fatal error on live when trying to access post type edit screen
- Query sql for truncate post_content in wp_posts table
- How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
- Foreach only outputs if id is 0
- Using queries in and i see 7000+queries?
- “Error 1064” when importing msql database after updating wordpress version to 4.2.1
- remove wordpress post links
- SQL get last entry of a specific gravity form
- mysqldump to a tar.gz
- Postgres equivalent to MySQL’s \G?
- How to check what port mysql is running on
- Where is my mysql log on OS X?