phpmyadmin

[zander]

hi,

i need to use phpmyadmin to create a mysql database for wordpress. i have little exposure to using these applications.

as far as i can tell (with help from some in previous posts here) i have everything i need in place to achieve this.

for clarity i will state again that i am trying to install wordpress on my b2. i am at the step in the install where i must use phpmyadmin to create the mysql database "wordpress".

i know phpmyadmin is installed because i have logged into it before. but was reluctant to use it or even keep it because i could not set the admin/root password for it. the phpmyadmin root/admin password was blank (which is its default).

so my question(s) are how do i set the phpmyadmin admin/root password and then then how do i use it to create the mysql wordpress database?

also i forgot where i log into phpmyadmin.

mainly the login address and procedure to set the phpmyadmin root password are what i need because the phpmyadmin interface seemed intuitive enough but somehow i could not set the root password for it using what i perceived to be the functions given to do this on the phpmyadmin admin page.

i am okay with basic linux admin but i have never used the apps i listed here so i am not sure what to do if a step is not set out in detail in the instructions.

please advise.

thank you for help with this.

[Kiff]

Where you log into phpmyadmin depends on where you stored it on your harddrive. If it is in /home/web/myadmin then try http://bubba/myadmin etc


My apologies for being one of those people who answers with a completely different approach than you asked for (I know very little of wordpress or phpmyadmin), but if you are just creating a database and are not afraid of a little command line, you could try this:

Log into mysql:

Code: Select all

mysql -u root

Create the database in mysql and create a user (replace username and password with desired values)

Code: Select all

create database wordpress;
grant all on wordpress.* to 'username'@'localhost' identified by 'password';
flush privileges;
exit

You can test your login with

Code: Select all

mysql -u username -p
use wordpress;
show tables;

The response should be 'empty set'

[zander]

ty kiff,

i like to do things the easiest way that works.

using the command line is better for me. i am much more comfortable with it than with unfamiliar guis.

i am just about to go to bed here in the western us but i will use your method as soon as i review what i have to do with respect wordpress and mysql to get wordpress working on my b2.

thank you for your help. it seems much easier the way you suggested.