MySQL getting started

[TheGoldenShogun]

Since this seems to be the PHP and MySQL forum, I just installed MySQL on a new server and, where do I go from here. I cant create a database until I get a user and I can get a user until I get a database, right? Or maybe I'm just lost. And I installed phpMyAdmin but when I tried to run it I got this...

The $cfgPmaAbsoluteUri directive MUST be set in your configuration file!

[scoutt]

ok first you have to set a root login and password. then from there you can create a table and another user if you want.

phpmyadmin won't run unless you have a DB setup already.

then do this to setup the root and pass.

You should also add a password for the root user. The following example starts by removing the anonymous user that can be used by anyone to access the test database, then sets a root user password:

C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysqladmin -u root password your_password

After you've set the password, if you want to take down the mysqld server, you can do so using this command:

C:\> mysqladmin --user=root --password=your_password shutdown

that is if you are on windows. read this if different

http://www.mysql.com/documentation/m...ult_privileges

if you setup a root password and login, you can then set phpmyadmin to the test database then you can setup other tabels.

but you have to have root login to make other users.

does tht help a little?

[TheGoldenShogun]

its helping a little bit, umm I tried starting it and messed around with it beforehand so when i try the ol'

./bin/safe_mysqld --user=mysql &

to get it going it says...

A mysqld process already exists.

And when I tried to do this little ditty...

./bin/mysqladmin -u root -p password 'whatever';

It prompted me for the password again, I entered it again and got this..

./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

maybe I need to restart the mysql server but cant seem to figure out how. mysqlserver.stop gives me a command not found.

I'm think I'm getting somewhere but dont know.

[scoutt]

you typed in the wrong password for the root. you should clear it out and then startoveror change teh password since you don't know what it is.

looks like you are on a *nix server correct? did you try quit?

[TheGoldenShogun]

maybe I did enter the wrong password, but I should be entering the password that my root has right? Or which password should I be entering? Yeah I'm on a Linux.

[scoutt]

ya you should be using root password.
this:

'Access denied for user: 'root@localhost' (Using password: YES)'

means that you either typed it wrong or there is no passowrd for root.

try clearing it and reseting it (the password that is)

[TheGoldenShogun]

ok, I read up on the documentation and realized the initial password is set to nothing and you have to change it later... it helps to read I guess. Now what do I from here?

[scoutt]

ok, so you are logged on as root now?

then you can make tables or add users. or you should be able to get phpmyadmin running.

[TheGoldenShogun]

nevermind I got it! WOO HOO! I dont have to use postgres on this project! Yeah! Thanks again scoutt, you've saved me again.

[scoutt]

what was teh final outcome?

glad you got it working

[TheGoldenShogun]

actually I guess I counted my chickens before they hatched. Everything is working, I can create users but still the phpMyAdmin page is giving me the same error. I'm in mysql now and I can create databases and stuff under the root but I would like to get the phpMyAdmin to work. Any ideas?

The error I'm getting is ...

The $cfgPmaAbsoluteUri directive MUST be set in your configuration file!

[scoutt]

in your phpmyadmin config file you need to set the username and passowrd and the database it needs to connect to.

[TheGoldenShogun]

cha-ching, I just needed to set the user and the filepath of the phpMyAdmin. Everything is working now! (does a little dance) Thanks again for all your help scoutt.

[scoutt]

cool, your welcome

[nabeels786]

what i did was install mysql, then goto

C:\Inetpub\MySQL\bin (where i have it installed)
and i ran winmysqladmin.exe, and click on my.ini Setup on top, and added under "[WinMySQLadmin]"

user=user
pass=pass

thats how i got it work, dunno about that root stuff

[scoutt]

sure that works on a windows system, but not on linux.