First, I decided to set a password by reading the documentation. So I set it to 1234. Now it won't let me use mysql anymore, it won't accept that password.

I type mysql -u root 1234 and I get access denied. I tried mysql -u root -p 1234 then it asks for a password, so I put that, access denied again. Why is it doing this?

Another problem, I installed phpmyadmin, but when I open it I get this error:

Fatal error: Call to undefined function: mysql_get_client_info() in /var/www/html/phpmyadmin/libraries/defines.lib.php on line 47


Why? I'm running php 4.2.2 and phpmyadmin requires php 4.1.something.

I'm not sure what version of mysql I'm running because of the first problem, it won't let me do the mysql -v command. It just says access denied.

Thanks in advance.

MySQL syntax is kind of goofy. If I remember correctly, you can't have a space between the -p flag and the password. So the line might be:

mysql -u root -p1234

You can also use mysql -u root -p and then mysql will prompt you for the password.

Of course, be sure that mysqld is running

That sort of works, but even now that I'm logged in, it won't let me do anything. It keeps saying access denied.

mysql> \u mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>

It sounds like you haven't granted privileges to the user. You probably want to have a bit of a read here at MySQL

Tried all of that, still not working. Here's a typical session:










[root@borg root]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[root@borg root]# mysql -uroot-p1234
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 3.23.52

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from mysql;
ERROR 1046: No Database Selected
mysql> \u mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql> set password for root = password("");
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'


Even once I log in, it's still complaining that I don't have permission, that's what I don't get. If I did mysql -uroot-p1234 the first time, why does it not get the point that I logged in and let me do what I need?

Also, I installed phpmyadmin, but when I open it I get this error:


Fatal error: Call to undefined function: mysql_get_client_info() in /var/www/html/phpmyadmin/libraries/defines.lib.php on line 47

Why is it using functions that don't exist? Do I need to install some kind of library or something?

Hm. OK, did you install from an rpm or did you install from source? If you installed from rpm, the various set-up scripts should have been run for you, but if you installed from source, you need to run the scripts (see the install documentation for details). Those scripts set up the initial root permissions. The MySQL site has a section on access denied errors and I'd be real tempted to run through some of the tests their. If this doesn't clear up, you could also run mysqld with the --skip-grant-tables flag. That should give root complete access to the databases.

Finally, I'm not familiar with the /u syntax. Does plain old use mysql work?

Have just started using mysql myself. Noticed it gets excited about the name of the computer; after all it's a server/client thing.

Perhaps look in /etc/hosts is it?

Perhaps start with:
mysql -u <username> -h <hostname> whatever

or something.

MySQL's 'root' is not the same as 'root' the superuser.

I did not install it, it's the same one that comes with red hat. the /u is to use the database, I have not tried use, I guess it's the same thing. I just typed help and it said /u. I'll try the --skip-grant-tables thing and see what happens.

To switch databases, use the 'use' command:

mysql> use <database-name>