Here is what I did:
Code:
bash-3.1# cp /etc/my-small.cnf /etc/my.cnf
bash-3.1# /usr/bin/mysql_install_db
Installing all prepared tables
Fill help tables
Quote:
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
|
?Where is the right location for Slackware12?
mysql had been trying to star tat boot time but would end and now there is no "end" message.
Currently:
Code:
bash-3.1# slocate /mysql.server
/usr/share/mysql/mysql.server
/usr/man/man1/mysql.server.1.gz
Setting Password lost me. Is 'new-password' part of the command? Or am i supposed to write a text legible password in that space? If not once you hit enter all there is- is a green square sitting on the screen? How do I do this??
Start server.
Code:
bash-3.1#/usr/bin/mysqladmin -u root password 'new-password'
bash-3.1#/usr/bin/mysqladmin -u root -h NASCI password 'new-password'
"See the manual for more instructions." Where is this manual? How do I log onto MySQL?
Man Pages are gz how do I open then?
I found lots instructions other than Newbie Admin Guide, posts, and forum but not for slackware12. I did setup group and usr without home or group.
Mysql is the user name I set, mysql also shows up in /etc/group.
Code:
bash-3.1# ps -A | grep mysql
3163 ? 00:00:00 mysqld_safe
3197 ? 00:00:00 mysqld
bash-3.1# ls -| /var/lib/mysql
bash: /var/lib/mysql: is a directory
bash-3.1# cd /var/lib/mysql
bash-3.1# ls
NASCI.err ib_logfile0 ib_logfile1 ibdata1 mysql test
bash-3.1# cd mysql
bash-3.1# ls
columns_priv.MYD help_relation.frm time_zone.MYI
columns_priv.MYI help_topic.MYD time_zone.frm
columns_priv.frm help_topic.MYI time_zone_leap_second.MYD
db.MYD help_topic.frm time_zone_leap_second.MYI
db.MYI host.MYD time_zone_leap_second.frm
db.frm host.MYI time_zone_name.MYD
func.MYD host.frm time_zone_name.MYI
func.MYI proc.MYD time_zone_name.frm
func.frm proc.MYI time_zone_transition.MYD
help_category.MYD proc.frm time_zone_transition.MYI
help_category.MYI procs_priv.MYD time_zone_transition.frm
help_category.frm procs_priv.MYI time_zone_transition_type.MYD
help_keyword.MYD procs_priv.frm time_zone_transition_type.MYI
help_keyword.MYI tables_priv.MYD time_zone_transition_type.frm
help_keyword.frm tables_priv.MYI user.MYD
help_relation.MYD tables_priv.frm user.MYI
help_relation.MYI time_zone.MYD user.frm
I do have a host error log.. too big to post here the high ligts:
Code:
071226 5:01:59 [ERROR] Fatal error:Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
13 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
Will try to edit out that data file but problem is I don't know how to set password, at this point reset... so i can get into mysql.
I have tried to piece this setup process from all kinds of resources caveat is that some configuration is Distro specific and most instructions do not explain how commands work. ie. You write this and expect this, do this... insert actual password here or when...some event happens.
Thank you in advance.
Will go read,do this. Let u know outcome. Many thanks to u
