forum.excito.org

Posted: **11 Feb 2010, 18:28**

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.

Posted: **12 Feb 2010, 03:04**

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'

Posted: **12 Feb 2010, 04:33**

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.

forum.excito.org

phpmyadmin

phpmyadmin

Re: phpmyadmin

Re: phpmyadmin