Lewis Rosenthal

Hmmm… I guess the 30-day trial of Navicat would do it, if one didn’t see the value in paying for a management utility beyond the initial installation. Thanks for the mention; I wasn’t aware of this product before.

From my perspective, it’s still fairly easy to just use mysqladmin from a prompt, or for a free web-based tool, set up Apache on the local workstation and install phpMyAdmin on that (or something already packaged, like USB Webserver).

As for cPanel and “one button” installs, as I’ve always done my own web hosting and have never worked with cPanel, I’ve never had the opportunity to see this type of management interface in action. So, I’m pretty much coming from the other side of the fence! ??

Cheers

You bet!

I take it this is the first CMS (Content Management System) you’ve set up and/or the first PHP-driven site you’ve done. They’re all pretty much the same with regard to the order of the installation steps: create db & user, upload archive, extract files, open install script from browser, run through the guide (or “wizard,” in MS-speak).

I’ve been setting these things up on my own box (besides IT consulting, I do mail, web, & FTP hosting) for several years. Much of this has become more and more automated. I do recall when we had to manually execute the SQL to create the tables, and before that, when there were just a handful of tables (other apps, not necessarily WP, which I started fiddling with in the 2.7-2.8 release cycle), we used to have to manually create tables. These days, however, there are just so many checks which need to be done in terms of PHP configuration, the sheer number of db tables, and so forth, that it doesn’t make sense not to automate as much as possible, if only to cut down on support effort.

Let me know if you get stuck again. ??

Please read the documentation.

VNC is a remote control application. I believe what you are saying is that you used VNC to gain remote access to the server, and from there, you downloaded the archive (zip file), and extracted it.

You need to make sure that you extracted it in a/the web-accessible directory (or, in the case of an internal web, an intranet, in a space accessible by the clients who need to use the application and served by the web server engine). Next, you need to create the database (a blank database, with no tables) on the MySQL server (which may or may not be hosted on the same physical box as the web server). Then, create a user account (privileges) which WP will use to access this new database.

Follow the instructions to then access the installation script (yes, this is automated, and part of what you unzipped) from a browser (see step 6 of the Famous 5-Minute Install) and run through the script. This will create the necessary database tables and do the basic configuring of the site.

Again, please, please, please read the documentation. I am happy to help, but you have to at least read the docs. ??

You only need to create the database, not the tables. The install script does the rest for you. I suggest you review the installation guide.

I’ve never used MySQL Workbench, but I understand that it’s fairly intuitive.

GL

To expand on the previous response, you’ll use mysqladmin, which is the command line admin utility which ships with MySQL. For insight on how to create a new database and new privs (a new user), see here, here, and the documentation, here (pick your current running version of MySQL).

It’s fairly easy to do this, after which, the WordPress installer really does the heavy lifting of importing the SQL to create the database schema.