I see this advice given everywhere and while I agree it's good for novice users someone who is experienced with the command line can move around as root with very little incident. The first thing I do when I log in is su - and have never suffered by it.
On Fri, June 16, 2006 3:31 pm, Shawn wrote: > Sorry, finished reading ALL my mail. > > > Just one comment here - using the root account to access your database > is most definetely NOT a good idea. You should create a user account > specifically for the database in question. But, get Drupal installed and > running once or twice before you worry about that. I just wouldn't go > into production with the root account... > > Shawn > > > Mitchell Brown wrote: > >> Thanks Gustin...found it! >> >> >> [EMAIL PROTECTED]:~$ sudo /opt/lampp/bin/mysqladmin -u root -p create >> drupal Enter password: >> /opt/lampp/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't >> create database 'drupal'; database exists' [EMAIL PROTECTED]:~$ sudo >> /opt/lampp/bin/mysql -u root -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 57 to server version: 5.0.21 >> >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> >> mysql> GRANT ALL PRIVILEGES ON drupal.* -> TO [EMAIL PROTECTED] >> IDENTIFIED BY 'apt=olex'; >> Query OK, 0 rows affected (0.00 sec) >> >> >> mysql> flush privelages; ERROR 1064 (42000): You have an error in your >> SQL syntax; check the >> manual that corresponds to your MySQL server version for the right syntax >> to use near 'privelages' at line 1 mysql> flush privileges; Query OK, 0 >> rows affected (0.03 sec) >> >> mysql> \q Bye >> [EMAIL PROTECTED]:~$ sudo /opt/lampp/bin/mysql -u nobody -p drupal < >> database/databse.mysql -bash: database/databse.mysql: No such file or >> directory [EMAIL PROTECTED]:~$ sudo /opt/lampp/bin/mysql -u nobody -p >> drupal < drupal/drupal.mysql -bash: drupal/drupal.mysql: No such file or >> directory [EMAIL PROTECTED]:~$ sudo /opt/lampp/bin/mysql -u nobody -p >> drupal < database/drupal.mysql -bash: database/drupal.mysql: No such file >> or directory [EMAIL PROTECTED]:~$ >> >> >> >> I'm stuck from here :-/ >> How can I >> > > > > _______________________________________________ > clug-talk mailing list [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying > > _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
