MySql doesn't seem to work right?

natewlew · 06-24-2006, 02:03 AM

I followed this guide at: The perfect suse setup and for some reason I can't add a user to a database. I installed ispconfig and I can't login. I think something is wrong with my database.

Here is what happens when I try to add a user to a database:

Quote:

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.18

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

mysql> CREATE DATABASE ipconfig03;

mysql> use ipconfig03;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'localhost'
'> IDENTIFIED BY 'mypass' WITH GRANT OPTION;
'> GRANT ALL PRIVILEGES ON *.* TO 'myuser'
'> IDENTIFIED BY 'mypass' WITH GRANT OPTION;
'>
'>
'> Aborted

Then I have to hit Ctrl-C.

After I installed ispconfig I ran:

Quote:

mysql> SHOW TABLES;
Empty set (0.00 sec)

I don't know what is going on?

paulsm4 · 06-24-2006, 02:12 AM

You typically log on to mysql like this:

Quote:

mysql -uSOME_NON_ROOT_USER -pPASSWORD MYDATABASE

You then need to:
1. "create database"
<= This creates the database
You can also do it with "mysqladmin"
2. "create table"
<= This is the step it sounds like you were missing
3. "grant ... privileges"
<= You can do this to set permissions; it also lets
you create new mySQL users on-the-fly

Please go back to the instructions - it sounds like maybe you missed the "create table" part.

'Hope that helps .. PSM

natewlew · 06-24-2006, 03:32 PM

I thought Ispconfig would create tables if I gave it a username and password.

I had Solaris 10 running and all I had to do was create a database and then:

Quote:

shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Then I could install PhpBB?