
09/01/2008, 08:30
|
| | Fecha de Ingreso: enero-2008
Mensajes: 7
Antigüedad: 17 años, 2 meses Puntos: 0 | |
Re: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server intente con el comando que me mencionaste, pero no se ver si la base de datos tomo este comando.
te envio los comandos que he ejecutado y lo que me muestra ahora el mysql me funciona y el semafora esta en verde pero me sigue arrogando el mismo error
C:\mysql\bin>mysql --user=root --password mysql
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 65 to server version: 4.0.24-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from dba_objects;
ERROR 1146: Table 'mysql.dba_objects' doesn't exist
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
mysql> show tables user;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'user' at lin
e 1
mysql> show user;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'user' at lin
e 1
mysql> select * from user;
+-----------+-----------+------------------+-------------+-------------+--------
-----+-------------+-------------+-----------+-------------+---------------+----
----------+-----------+------------+-----------------+------------+------------+
--------------+------------+-----------------------+------------------+---------
-----+-----------------+------------------+----------+------------+-------------
+--------------+---------------+-------------+-----------------+
| Host | User | Password | Select_priv | Insert_priv | Update_
priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Pro
cess_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_
priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer
| x509_subject | max_questions | max_updates | max_connections |
+-----------+-----------+------------------+-------------+-------------+--------
-----+-------------+-------------+-----------+-------------+---------------+----
----------+-----------+------------+-----------------+------------+------------+
--------------+------------+-----------------------+------------------+---------
-----+-----------------+------------------+----------+------------+-------------
+--------------+---------------+-------------+-----------------+
| localhost | root | 3f99a78f742bfb93 | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y | | |
| | 0 | 0 | 0 |
| localhost | | | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
N | N | N | N | N
| N | N | | |
| | 0 | 0 | 0 |
| localhost | cactiuser | 2d6bfde554cd0e36 | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
N | N | N | N | N
| N | N | | |
| | 0 | 0 | 0 |
+-----------+-----------+------------------+-------------+-------------+--------
-----+-------------+-------------+-----------+-------------+---------------+----
----------+-----------+------------+-----------------+------------+------------+
--------------+------------+-----------------------+------------------+---------
-----+-----------------+------------------+----------+------------+-------------
+--------------+---------------+-------------+-----------------+
3 rows in set (0.28 sec)
mysql> |