WordPress.org

1. JimboFett
   Member
   Posted 5 months ago #

   I'm wanting to install wordpress on our dedicated server. Due to security concerns (I'm doing this for a computer security company) I cannot install PHPmyadmin. And cPanel is out of the question too.

   The server is a Mac Mini. The only tools at my disposal are the server tools on the Mac Mini.

   My first quess is to ask if there is there some kind of schema/script that can be run to create the DB?

   What are my options in creating the proper DB for WP when I have neither PHPmyadmin nor cPanel at my disposal?

2. maoski
   Member
   Posted 5 months ago #

   phpmyadmin is just a gui for mysql, use phpmyadmin installed on another machine to connect to the database on the dedicated server

   try this

3. fonglh
   Member
   Posted 5 months ago #

   Or just use the command line.

4. LewisR
   Member
   Posted 5 months ago #

   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.

5. JimboFett
   Member
   Posted 5 months ago #

   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?

6. LewisR
   Member
   Posted 5 months ago #

   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

7. JimboFett
   Member
   Posted 5 months ago #

   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.

8. LewisR
   Member
   Posted 5 months ago #

   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. ;-)

9. JimboFett
   Member
   Posted 5 months ago #

   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.

10. LewisR
    Member
    Posted 5 months ago #

    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. ;-)

11. JimboFett
    Member
    Posted 5 months ago #

    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.

12. jkwcape
    Member
    Posted 5 months ago #

    I use Navicat to connect and configure my client's MySQL databases. It's a great tool.

13. LewisR
    Member
    Posted 5 months ago #

    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

Reply

You must log in to post.