Niakoi da ima na ideia kak se adva admin user v MySQL 
za FreeBSD 4.8-Release e versiata

bash-2.05b# pkg_info |grep mysql
mysql-client-4.0.14 Multithreaded SQL database (client)
mysql-server-4.0.10 Multithreaded SQL database (server)
bash-2.05b# mysql --user=root mysql
 ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
bash-2.05b# netstat -na|grep *.3306
 tcp4       0      0  *.3306                 *.*             
      LISTEN

 momenta e tochno sled addvaneto na packija i ne mi e iasno
 kak moje da se add-ne user bez da se da vliaza v mysql
clienta. 

nachi v Reference Manual-a pishe taka

--safe-user-create
     If this is enabled, an user can't create new users with
 the GRANT command, if the user doesn't have the INSERT
 privilege for the mysql.user table. If you want to give a
 user access to just create new users with those privileges
 that the user has right to grant, you should give the user
the following privilege:

 mysql> GRANT INSERT(user) ON mysql.user TO
'user'@'hostname';

     This will ensure that the user can't change any
 privilege columns directly, but has to use the GRANT command
to give privileges to other users.


bash-2.05b# mysql --safe-user-create localhost 3306
mysql: unrecognized option `--safe-user-create'
 mysql  Ver 11.18 Distrib 3.23.55, for portbld-freebsd4.8
(i386)
 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX
DataKonsult AB
 This software comes with ABSOLUTELY NO WARRANTY. This is
free software,
 and you are welcome to modify and redistribute it under the
GPL license
 
Usage: mysql [OPTIONS] [database]
 
  -?, --help            Display this help and exit.
   -A, --no-auto-rehash  No automatic rehashing. One has to
use 'rehash' to



i nadolo e celia Help... 


Po diavolite ne znam kakvo stava ???
Help

bash-2.05b# mysql --user=root mysql

 А какъв е смисълът на тази команда? Какво искаш да постигнеш
с нея? Просто не я даваш правилно:

mysql -u root -p

Ще ти поиска парола, даваш я и влизаш в конзолата.

 N.B. При първоначална инсталация няма администраторска
парола!

 Mi az 4eta v MySQL Reference Manual for version
4.0.10-gamma.
 to si mi se instalira v
/usr/local/share/docs/mysql/manual.html
 4eta si si4ko nared i ne raboti moje bi neshto pravata na
root ne sa kakto triabva ???

zashtoto i tova koeto ti mi kazvash ne stava ... 

bash-2.05b# mysql -u root -p
Enter password:
 ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
bash-2.05b#

 haha vij obache tfa sraboti :) mai admin user-a se kazva
mysql v FreeBSD :)) ne e kato v Windows root i bez pass :))

-bash-2.05b$ mysql -u mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 33 to server version:
4.0.10-gamma
 Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql>

mysqld_safe --skip-grant-tables

 tova reshi si4ki problemi i sega moga da se logvam i s user
root
 pone dokato si opravia permishanite. predpolagam che shte e
 ot polza i za drugi s podoben problem kato moia. Okaza se
 che niama nishto obshto s FreeBSD a si e problem na MySQL
 prosto kato se preinstalira ne si iztriva vsi4ki
konfiguracionni failove.

 sled kato si opravite permisha e nujno pak da se restartira
demon-a

pove4e info moje da vidite tuka 
http://www.experts-exchange.com/Databases/Mysql/Q_20683995.html

 tuka vinagi sa gotovida vi pomognat pri problem s kakvato i
da e DB