A little bit of help from some one who is recovering from Xmas parting.......
I am having a few problems. 1.) I compiled and installed as root then changed the ownership to the "dba" account. Will this cause any problems down the line. IF you do the normal mysql install you will have added a user Mysql so as long as you have done the same with user dba you should have no problmes 2.) Is there s startup and shutdown script to put in /etc/rc.d/init.d or do I have to write my own ? I think you should use mysqladmin but not shore about this... 3.) I su to the dba account and want to a set the superuser password (for the mysql install not the OS) how can I do this. 4.) I su to the dba account and try to do anything I get e [mysqldba@jordan bin]$ ./mysqladmin create bathjobs ./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'bathjobs'' Ok when you install MySQL you just log on /use/local/mysql/mysql But what you should have done is set the root password using mysqladmin then you would log on /usr/local/mysql/mysql -u root -p Then enter you pass word you just set..... The rest would be done by using GRANT..... I hope this helps a bit..... Simon thanks in advance. PS I am finding this list a great help. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
