Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
You need to set a user in MySQL with privileges to that database. From the
mysql console:
mysql GRANT options ON database_name.* TO user@'217.219.201.2'
IDENTIFIED BY 'password' USING GRANT OPTION;
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
That's weird, since I have only seen the RPM install the databases into
/var/lib/mysql, while the binaries install into /usr/local/mysql
Did you find the hostname.err file in /var/lib/mysql/data?
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Is this user a super user, or do they only have access to a single DB?
If they are a super user, try changing the password using mysqladmin -u
ackerley password 'newpassword'
If this user only has access to a single db, alter your mysql command to:
shell mysql -u ackerley -p 'database_name'
Then like Richard Davey sent earlier to the list, try:
shell mysql -u root
If you haven't created the users yet with the mysql tool, then your user
won't have access to it. First, change the root password using:
shell mysqladmin -u root password 'new_password'
Then log into mysql and use:
mysql
I have run into this countless times. The 'easiest' way to fix this is to
set your hostname back to localhost, run the scripts/mysql_install_db, then
change your hostname back to whatever you need it to be. I don't understand
why it happens, I just know that is the 'easiest' way to fix it.
J.R.
First of all, get rid of Windows and use Linux =)
Secondly, try downloading the newest version 4.0.18-nt from mysql.com. That
will help you out. I run both Windows, Mac, and Linux versions of MySQL and
haven't had any problems with the MySQL installer for any OS.
If you have any other questions,
You can also rerun the scripts/mysql_install_db
This will reinstall the mysql.hosts form and allow you to reconnect to your
server.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
changes are up for grabs.
Should I change this to PHP? Will that help any at all?
Is this database just going to get too big for it to be quick over the Web?
Any information needed will be immediately posted.
Thank you so much!
J.R. Bullington
Innovatim Technical Support
[EMAIL PROTECTED
you to see your tables, ergo solving your
database.table issue.
J.R. Bullington
Innovatim Technical Support
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB uses a single file (filename.frm) for each table and then stores
other database information in an InnoDB general file, named in your
innodb_data_file_path=innodbdata:xxM
Hope this helps a little!
J.R. Bullington
Innovatim Technical Support
[EMAIL PROTECTED]
--
MySQL General Mailing
You have to re-run the ./scripts/mysql_install_db
I had this exact error and it comes from deleting (or not installing) the
'mysql' database, which is a required component for MySQL to run. It also
installs a db called 'test' which is not required.
J.R. Bullington
Innovatim Technical Support
K. Here are the step-by-step instructions that might help.
1 - Download and unpack the tar.gz file from mysql.com/downloads
2 - Open the Users panel and add a new user called 'mysql' with whatever
password you choose.
3 - Open Terminal.app and log on as root
4 - [/] root# cd /usr/local/mysql (or
101 - 113 of 113 matches
Mail list logo