JimboFett

This is the first time I’ve had to install WordPress on a server without access to cPanel or MyPHPadmin. Usually, I’ve been able to just use something like Fantastico to install WP because the sites I’ve done have been hosted at hosting companies. Because of those dummy-proof installations I’ve never had to learn/understand MySQL.

This is the first time I’ve had to set one up on a client’s dedicated server – and one that has such tight restrictions on what can and can’t be installed.

Thanks, Lewis. You really helped me understand the mechanics behind the process. My brain wants/needs to understand why/what I’m doing something and not just how I’m doing it.

I had read the documentation several times and just wasn’t connecting the dots.

Sorry if I’m being a bit daft but I didn’t install WordPress using an install script. I had to just download the ZIP, extract it and put it on the server via VNC.

That’s where I’m a bit lost in understanding the process – getting WP to create the tables. In the past I’ve always used cPanel or PHPmyAdmin but my client doesn’t allow web access to MySQL except through their current site which is Joomla-based.

I found on the server the app MySQL Workbench. I’m still at a loss of how to create the database tables for WordPress. Do I have to do each one manually? Is there a schema file or .sql file I can run to automate this process?