so i'm slaving away with this time...from installing codecs to watch my videos, getting updates to certain programss all went well...

now i trying to set up apache, php and mysql..
got through all up to the point where i installed phpmyadmin..ran the page in firefox and it asking about username and password..and me stuck thereso cause me nuh know what the password is or how to figure it

follow these intructions and you should be fine


1. Stop MySQL

[root@bigboy tmp]# service mysqld stop
Stopping MySQL: [ OK ]
[root@bigboy tmp]#

2. Start MySQL in Safe mode with the safe_mysqld command and tell it not to read the grant tables with all the MySQL database passwords.

[root@bigboy tmp]# safe_mysqld --skip-grant-tables &
[1] 4815
[root@bigboy tmp]# Starting mysqld daemon with databases from /var/lib/mysql
[root@bigboy tmp]#

3. Use the mysqladmin command to reset the root password. In this case, you are setting it to ack33nsaltf1sh.

[root@bigboy tmp]# mysqladmin -u root flush-privileges \
password "ack33nsaltf1sh"
[root@bigboy tmp]#

4. Restart MySQL normally.

[root@bigboy tmp]# service mysqld restart
Stopping MySQL: 040517 09:39:38 mysqld ended
[ OK ]
Starting MySQL: [ OK ]
[1]+ Done safe_mysqld --skip-grant-tables
[root@bigboy tmp]#

The MySQL root user will now be able to manage MySQL using this new password.

nothing doing...i looking to uninstall it and try to reconfigure it from the initial stages

k try this, i've done this before wayy back in the day when i used to run suse and i think i walked enigma through this one time if i'm thinking correctly


1. Kill the mysqld that may be running (not with -9):

kill `cat /var/lib/mysql/hostname.pid`

2. Restart MySQL in safe mode:

/usr/bin/safe_mysqld --skip-grant-tables&

3. Connect to MySQL:

/usr/bin/mysql

4. Use the mysql database:

use mysql;

5. Run the Update command putting your new password where the ....'s are. Yes this is all one command:

update user set password = password('.......') where user = 'root' and host='localhost';

6. Flush the privileges so everything will take:

flush privileges;

7. Then quit mysql:

quit

8. Stop mysql from command line with:

/etc/init.d/mysql stop

9. Restart mysql from command line with:

/etc/init.d/mysql start

new error....

Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

alright..here's the thing. i found the file with the socket thing however when i run the mysqld_safe it removes the file and when i try to restart mysqld it says that that particular file is missing

you probably gonna have to recreate the .so file, will post the instructions in a bit

you probably gonna have to recreate the .so file, will post the instructions in a bit
yeah cause that really is the only thing i dont know how to do now