Different hosts, different methods (my host provides a separate interface to create a DB, won’t permit creation in phpMyAdmin).
Check with their support?
Thread Starter
Jenkin
(@jenkin)
I got the databass created, thankfully. However, the next step in the installation process wants me to add a new user. The instructions say:
“Click the Home icon in the upper left to return to the main page, then click Privileges. If a user relating to WordPress does not already exist in the list of users, create one:
Click Add a new User.”
I don’t see a “Privileges” link/button nor do I see any way to add a user.
If I select my wordpress databass from the dropdown menu at the left my options at the right become, “Create new table on database…” and “Rename dtabass to:”
The option tabs at the top are “Structure” “SQL” “Export” “Search” and “Query”
If you are already in… you are the user 🙂
If the host created the DB for you they should have given you
the access info, too.
Which instructions are those?
Thread Starter
Jenkin
(@jenkin)
I created the database via MediaTemple’s database creator. That’s required because i can’t create the database in phpMyAdmin. My concern is that I haven’t set up a MySQL username or password. All I’ve done is created a database with a specific name. In this case, “wordpress” I haven’t actually created any users associated with it (that I know of.)
And these instructions are from ww.wp.xz.cn, http://codex.ww.wp.xz.cn/Installing_WordPress
The “database creater” is fine. Usually no hosts on a shared environment let you create DB in phpMyadmin.
On that same DB creator page/panel – don’t you have option to add a user to it?
(cPanel works like that, but I don’t know what MT has…)
Thread Starter
Jenkin
(@jenkin)
MT uses phpMyAdmin for their database management. And I can’t find how to add a user. I’ve gone through all the sections looking for any way to do it. it might be time to explore some phpMyAdmind support I suppose. I’ll dig around for that. Perhaps MT has removed some functionality from phpMyAdmin.
If I remember correctly your DB user is the same as your account user name with MT
Strange that it would let you create a db without a default(admin) user/pass…
I have exactly the same problems – my space is hosted by Streamline.net
The phpMyAdmin interface will not grant me access to create a new database or rename the default one, and there’s no option to add a new user.
Here’s a thought – could I use the default database, username and password without renaming anything? If I enter these into the ‘wp-config.php’ code would all my problems be solved!?
Apologies if that’s a daft suggestion – I’m very new to this!
I have exactly the same problems – my space is hosted by Streamline.net
You may not have exactly the same problem because hosts tend to be different and use different control panels.
I notice that your host also has a windows /linux option. Make sure you have the linux option.
I don’t see a major downside in trying whatever values you have for the config.php file. Check what errors you have afterwards?
I’m on a linux server – got that one covered!
Anyway, I got it sorted with the help of Streamline’s support team. Here’s what I know:
As Yosemite mentioned above, some hosts (including Streamline as it turns out) don’t allow subscribers to create/rename databases through phpMyAdmin directly – the feature is disabled. I had to contact them and ask them to do it for me – which they promptly did.
As a newbie, I was a bit thrown by the fact that all the WordPress installation guides tell you to create a new database and user with appropriate names. This is probably good practice but, as I discovered, you can actually use any existing database and user as long as you include the appropriate names in your ‘wp-config.php’ file.
I ended up just using the default database/user names that Streamline gave me and it’s all worked fine.
ben: Thanks for feeding-back to this thread, no doubt it will help someone else…
For Media Temple subscribers that are stuck on this phase, use the ‘create database’ function in the MySQL databases menu to create the database name.
it should automatically give you some funky ‘user_com_-_yourdatabase’ kind of name.
use that entire name as your database name and the prefix should be ‘user_com_-‘
…otherwise youll get the cant locate server error.
hope this helps some folks traped out there!
The DB user is always the same as the SiteAdmin user. You cannot create more users and it is not necessary to create another user. If you click on MySQL Administrator under the phpMyAdmin link in the Web Control, you will see the DB user and the option to set or change the password for this user.
