MySQL can't connect to localhost

By Anonymous (not verified) on 12 Jul 2003 at 13:52 UTC

www# mysqladmin -u jay -p create drupal
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'jay@localhost' (Using password: YES)'
www#

Does anybody know where I can configure localhost to my URL, or what I am supposed to do, thanks...

Comments

Mysql login?

torgeirb commented 12 July 2003 at 14:24

If you are running your own box you need to create a mysql user. If you're using a host, they will have to create a database for you. Some hosting environments allow you to administer your mysql db's using the ISP's control panel.

MySQL GRANT Install Instructions

(not verified) commented 16 July 2003 at 02:35

What then, does the average user without access to phpMyAdmin do? I installed Drupal back in May/beginning of June, following the install instructions at that time. Today my account with my host was switched to a new server. None of the account specs changed in the move except my MySQL password was reissued. Therefore, now I need to go and GRANT ALL PRIV... and use this new password in the command. I do this, and get an access-denied error. I contacted my host - they say I never had GRANT access. Was this step/process explained differently in the INSTALL instructions back in May/June? I am unable to execute this SQL and I cannot recall how I did it the first time around. Any ideas?

The only thing you should nee

torgeirb commented 16 July 2003 at 10:14

The only thing you should need to do is change the db password in includes/conf.php.

If you get mysql errors ('access denied'), your ISP must have done something wrong. Ask them to verify the login. Ask them if the name of the db has changed.

If ISPs doesn't have phpMyAdmin installed, customers can still install it in their own directory. If MySQL is running on a different server you might need to get some information from your ISP when configuring phpMyAdmin.

URGENT HELP MySQL & Python

se05216 commented 28 July 2003 at 00:52

Hi all,

I'm new in python programmin and I've tried to make a simple .py file to test mySQL system. I've used this web pages to start my program (the most important ones):
http://images.devshed.com/Server_Side/Python/PythonMySQL/PythonMySQL.pdf
https://www.nusphere.com/products/library/scripts_python_dbapi.pdf

But I allways have this problem in my first query. I think I am not doing something well in importing files. These web pages tell me I have to import sys and MySQLdb modules in order to get well. The resulting error is:

File "", line 10, in ?
File "/usr/lib/python2.2/site-packages/MySWLdb/cursors.py", line 61, in execure
r=self._query(query)
File "/usr/lib/python2.2/site-packages/MySWLdb/cursors.py", line 168, in _query
rowcount = self._BaseCursor__do__query(q)
File "/usr/lib/python2.2/site-packages/MySWLdb/cursors.py", line 112, in __do_query
db.query(q)
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax near '; direction CHAR(40); )' at line 1")

Hope someone could help me in anything or give me some solutions, examples, guides, etc.
Thanks for all,
Christal

PS: My error line is:
cursor.execute("CREATE TABLE maquinas(nombre CHAR(40); direccion CHAR(40); ) ")