Hi
Quote:
1)...Since you don't have a working root password, you must do this from the system level...
|
IMHO, not necessary. If your mysql-root does not have a password then don't use the -p argument at all.
I have RH and MDK, no Debian. I use mysql binary downloaded from mysql.com, not the one which comes with the OS CD. I don't know much about starting and stopping services either
.
Quote:
In the example he has...Does that make a difference?
|
not that I know of. The only confusion is that mysql-server-admin is by default called 'root' and so is the Linux admin.
Quote:
I'm being really specific ...I type: $su mysql
|
Yes.
Quote:
/path/to/mysqld --skip-grant-tables &...jumps to a blank line...Once at the shell I type just type "mysql" as instructed and then I get mysql> Is this correct?
|
Usually I get a msg about mysql-server starting. I've never seen a blank line, maybe its peculiar to your distro or due to the & which pushes the service to the background (not sure about this).
Anyway, when you get a blank line do
ps aux and find out if mysqld is running. If its running, then do this -
* ./mysql (no arguments necessary coz grants are skipped)
* mysql > set password for 'root'@'localhost'=PASSWORD('new_password'); (sets password for mysql's root on localhost)
* mysql > flush privileges; (reload privilege tables)
quit mysql-client and restart mysql-server, this time without the --skip-grant-tables option.
Quote:
there are two ways "user" is printed, (user and User). Do I replace "User" with an actual user or something else, and does 'root'== 'mysql' in my situation.
|
, you should've checked the mysql manual for UPDATE syntax. The first 'user' is the name of a table in mysql database, the second 'User' is a column-name in table user. Column-names are NOT case sensitive.
Quote:
I'm really sorry to bug man...
|
you aren't. Please read the online manual first. All your questions are already answered in that very clearly.
SUMMARY
ensure mysql server is NOT running
* su mysql (switch-user to owner of mysql-directory)
* cd /mysql-directory/bin
* ./mysqld --skip-grant-tables (start mysql server with access to all databases)
* ./mysql (connect to mysql)
* mysql > SET PASSWORD FOR 'root'@'localhost'=PASSWORD('new_password'); (set password for mysql's root)
* mysql > flush privileges; (reload privilege tables)
* mysql > quit;
then repeat the 1-3 steps, but DON'T use --skip-grant-tables this time.
hth
theN