loading in grant tables

2003-09-03 Thread Gronquist, Jim M
I can log into mysql using

 

safe_mysqld --skip-grant-tables 

mysql -u root -mysql

 

The directions say that from mysql I should be able to manually execute
the SQL commands in mysql_install_db

and then run mysqladmin flush-privileges afterword.

 

It is not apparent to me how to manually execute the SQL commands in
mysql_install_db

 

Could somebody please help me get started with this?

 

-

Jim Gronquist



 



mysqlbug

2003-09-02 Thread Gronquist, Jim M
shell groupadd mysql
shell useradd -g mysql mysql
shell cd /usr/local
shell gunzip  /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell ln -s full-path-to-mysql-VERSION-OS mysql
shell cd mysql
shell scripts/mysql_install_db
shell chown -R root  .

shell chown -R mysql data

 

I'm getting the error: 

 

data directory doesn't exist

 

What is the most likely cause of this?

 

-

Jim Gronquist
Computer Network and Programming Analyst

Office of the Bursar

Indiana University

812.856.3026   x6-3026
[EMAIL PROTECTED]