mace19

The theme is a child theme of twentynineteen.. I know what you are thinking and I used a child theme of twentynineteen so that the theme would have all of the same files and I have made many child themes in the past without this problem.

There is not really a screenshot because the problem is that I cannot create a new page if I try to change the permalinks. When I try to create a new page and publish it, the page editor returns an error that says “failed to publish’ in a little red box at the top left of the screen.

@bigmoxy I worked around the problem by doing a fresh install of WordPress with a new database and then rebuilding my site so now I do not have the problem anymore but I still would like to know why changing the permalinks on two different servers (one unix and one windows) caused new page creation to stop working. Any ideas?

I renamed the installation folder via ftp and then edited the two database values manually for ‘home’ and ‘siteurl’ then I changed the permalinks from custom value that the installation starts with to posts (the second to last option on the settings page.

NEW:
I did a fresh installation of WordPress and it worked fine with my site but then when I edited the permalink settings it broke in the same way. Why can WordPress only have a custom permalink setting?

yes I did and a new URL for the site, why can’t I link to pages or create new ones anymore?

got it to work, thanks for everything! I uninstalled all old MySQL instances and used the Windows Web Platform Installer version.

Oh ok thanks, I do not have access to that server this weekend, but on Monday morning I will do both of those things!
Maybe I am misremembering but I did not see MySQL 5.7 as an option on Windows Web Platform Installer, so where would I install that from?

ok that worked, I was able to connect, but I also tried installing wordpress through Windows Web Platform Installer but the installation failed because it was unable to connect to MySQL, even though I am using the credentials that allow me to log in from the command prompt. Maybe I didn’t set up MySQL correctly?

mysql> SHOW GRANTS FOR root@localhost;
+——————————————————————————-
——————————————————————————–
——————————————————————————–
——————————————————————————–
——————————————————————————–
———————————+
| Grants for root@localhost

|
+——————————————————————————-
——————————————————————————–
——————————————————————————–
——————————————————————————–
——————————————————————————–
———————————+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS,
FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW
VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESP
ACE, CREATE ROLE, DROP ROLE ON *.* TO root@localhost WITH GRANT OPTION
|
| GRANT APPLICATION_PASSWORD_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_A
DMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,PERSIST_RO_VA
RIABLES_ADMIN,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,R
OLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SYSTEM_US
ER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `roo
t@localhost` WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON databasename.* TO root@localhost

|
| GRANT PROXY ON ”@” TO ‘root’@’localhost’ WITH GRANT OPTION

|
+——————————————————————————-
——————————————————————————–
——————————————————————————–
——————————————————————————–
——————————————————————————–
———————————+
4 rows in set (0.00 sec)

mysql>

(thats how the spacing is, I didn’t do that)

• This reply was modified 5 years, 5 months ago by mace19.

hmm, the Network Admins here say that yes it is, but is there a way I can check that the mysql processes are allowed to connect?

I have a feeling this problem is related to the firewall, but I don’t know how to check. The Windows Firewall is disabled and firewalling is handled by an outside service.

Thanks again for your help, any other ideas you have would be much appreciated.

• This reply was modified 5 years, 5 months ago by mace19.

damn, I really thought that was going to work!

ok I added the default_authentication_plugin=mysql_native_password under [mysqld] to my.ini and saved it. (I had to run notepad as administrator to save the file into the same place because it was overwriting the old version of that file)

There was no line in the file require_secure_transport = 1.

I restarted the MYSQL80 service and then tried to create the config file with the browser and then a file again:
Database Name: dbname
user: root
password:
Host: 127.0.0.1:3306
Prefix: wp_

error. I did notice that in the STATUS output above the charset for the server and the client is different… is that something that may cause this problem?

• This reply was modified 5 years, 5 months ago by mace19.

@diondesigns ok I did php -m and it looks like the modules listed both mysqli and mysqlnd. Do I need to run them with administrative privs somehow?

https://i.imgflip.com/1kkxr3.jpg

• This reply was modified 5 years, 5 months ago by mace19.
• This reply was modified 5 years, 5 months ago by mace19.

and a detail that might be relevant: when I edit the config file directly instead of use that web interface to create the file I still get the ‘Error establishing a database connection’ BUT with no explanation of the error after.

Thanks for the response, but I tried localhost, localhost:3306, 127.0.0.1 and 127.0.0.1:3306 but I am still getting the same error.

`
H:\>”C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe” -u root -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49
Server version: 8.0.16 MySQL Community Server – GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> STATUS;
————–
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe Ver 8.0.16 for Win64 on x
86_64 (MySQL Community Server – GPL)

Connection id: 49
Current database:
Current user: root@localhost
SSL: Cipher in use is XXXXXXXXXXXXXXX
Using delimiter: ;
Server version: 8.0.16 MySQL Community Server – GPL
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: cp850
Conn. characterset: cp850
TCP port: 3306
Uptime: 3 hours 30 min 25 sec

Threads: 2 Questions: 24 Slow queries: 0 Opens: 164 Flush tables: 3 Open ta
bles: 68 Queries per second avg: 0.001
————–
`

hello?