Mysql 4.0.18装好后无法连接

Mysql 4.0.18装好后无法连接 - 故障解答 - 电脑教程网

Mysql 4.0.18装好后无法连接

日期:2006-07-30   荐:
Mysql 4.0.18装好后无法连接RHEL as3 Mysql 4.0.18用SSH命令方式安装完毕并启动服务/usr/local/mysql/bin/mysqld_safe --user=mysql &提示.. started但用mysqlfront3.2连接时提示ccess denied for user: 'root@localhost' (Using password: YES)用SSH命令方式登录也不行,同样的提示/mnt/disk1/mysql/bin/mysql -u>>root -pXXXccess denied for user: 'root@localhost' (Using password: YES)/mnt/disk1/mysql/bin/mysql -u>>root -pXXX -h192.168.1.244(服务器IP)ccess denied for user: 'root@192。168。1。244' (Using password: YES)记得以前有文章说装好mysql好要先用mysqladmin给root用户授权什么的。麻烦各位大侠帮忙看看。百分感谢~~!自己先UP看来大侠们周末都在休息我再UP呵呵!是不是不能up了!我帮你!在不能使用sql语句,并忘记密码的时候,使用的几种方法:1、mysqld_safe --skip-grant-tables 这是在非windows下我一直没有体验过,看来楼主搞定并启动了,那么用mysql mysql确定你可以进入,说明mysql启动,然后quit退出mysql,然后mysqladmin -u root password 'pswd' 加入密码!2、这是我想到的!呵呵把别人的好的mysql文件夹拷过来即可,方便易行!常用的权限修改语句:grant语法:GRANT privilege[(column)][,privilege[(column)],...]ON table1,table2,...,talbenTO user [IDENTIFIED BY 'pswd'][,user [IDENDIFIED BY 'pswd'],...][WITH GRANT OPTION]例子:grant all privileges on db_name.* to your_user_name@’host_name’ identified by ‘your_password’ with grant option;非常感谢楼上 liuquanyi(大狗) 帮UP。先试试up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up up !你知道UP吧!!你试试看!!!
标签: