How to create MySQL database withOUT using PHPmyadmin nor cpanel

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

try this

Or just use the command line.

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.

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?

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

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.

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. ??

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.

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. ??

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.

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

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

@lewisr

I am having a similar problem. I am new to SQL and phpmyadmin etc.

I have a Mac Mini server at home with two domains registered on it. I currently am using OSX Mountain Lion Server application for web services, mail, VPN, etc. My goal is to reliably host and design wordpress sites from home. Where should I start with mySQL and phpMyadmin? I have viewed many, many forums online, and apparently there are very few people with this setup on forums like these. I have downloaded mySQL and phpmyadmin from their corresponding sites and am ready to install them on the mac mini. I also just bought a 6 TB Thunderbolt hard drive…so it’s a good setup to prepare for this type of thing.

Any advice or guidance is greatly appreciated.

Thanks

B

You could just install MAMP, I understand that it sets up everything for you.

@bernst2008

I can’t give you a lot of specific advice concerning the Mac, as I run on other platforms (OS/2, Linux, and NetWare), but the concepts are pretty much the same.

To install MySQL – on the platforms I use, at least – it’s a simple extraction into the root of the drive, which creates a /MySQL directory. Typically, there’s a /MySQL/data directory (among others) which will hold your data files (you can relocate this, of course, setting the datadir option in my.cnf, the configuration file for MySQL). The docs are very good: https://dev.mysql.com/doc/refman/5.6/en/index.html . There are even chapters relating to installation on OS X: https://dev.mysql.com/doc/mysql-macosx-excerpt/5.6/en/index.html .

For phpMyAdmin, peruse the docs at https://www.phpmyadmin.net/home_page/index.php to get an idea of how to install it so that you can log in, at least. Create a couple test databases for yourself, just to get a feel of the interface.

After that, just follow the directions for setting up WP: https://codex.www.ads-software.com/Installing_WordPress .

A lot of reading, and you’ll undoubtedly do a few trial runs before you feel comfortable with it, but overall, it’s fairly simple (especially the WP installation). The initial db creation is covered in the WP installation docs (follow the links). Really, that’s the only interaction you’ll likely have with phpMyAdmin (though you should get into the routine of backing up your hosted databases at least nightly – most MySQL installations come with scripts to do this, but you can do them manually from phpMyAdmin).

I wish I could give you more specifics from personal experience, but I’ve never done any of these installs on OS X, as I say.

GL