Originally Posted by jun_tuko
hello database gurus,
i have another one for you guys. i am getting this error:
[root@bluebananas mysql]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
i don't know what's going on. i can get in, however, after providing a password, using command:
[root@bluebananas mysql]# mysql -u root -p mysql
but using commands:
1) mysql (plain)
2) mysqladmin variables
gave me the access error.
My guess, as I'm no guru yet, but did have the same problems you are having, is that the vanillya mysql command assumes the current user with no password. Now, this is fine if you don't care about security. My solution to this was to simply add to my ~/.bashrc file:
alias mysql="mysql -p"
Then the mysql command will use the current user, and prompt for a password.
i have a webserver running using apache and php (works fine). i'm trying to integrate and use mysql to my system. i copied a php script from a book to test my php-apache-mysql connection but its not giving me any expected output.
you will notice that i placed "echo" before and after mysql_connect. it showed "connecting" on the browser, but seemed to hang because it does not show "after connecction".
here's the code:
$dbUser = 'test_user';
$dbPass = 'test_pass';
$dbName = 'my_test';
$dbHost = 'localhost';
$sql = mysql_connect($dbHost, $dbUser, $dbPass)
or die (mysql_error());
echo "After Connection";
mysql_select_db($dbName, $sql) or die (mysql_error());
This is my connection script for your reference:
<?php # Script 6.4 - mysql_connect.php
$dbc = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Could not connect to MySQL: ' . mysql_error());
Maybe, this will be a little more verbose, but the define statement may be a little more robust than just assigning a value? Maybe, a true guru can answer that one.
I don't know the answer to the last question, so hopefully someone else will come along with another answer.