</datasources> 我用root登录还是不行 Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user: 'root@SHEN' (Using password: YES)")
mysql>grant select,insert,update,delete on eM3000.* to shen@localhost identified by "123"; 这样设置的用户名:shen和密码:123,用程序调用还是不性 出现同样的问题
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'something' WITH GRANT OPTION;mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql> FLUSH PRIVILEGES;
2.用户名、密码、允许访问数据库的IP地址、数据库访问权限...这些设置正常了吗?
linux的权限好像真的很麻烦
那我怎样才能修改权限,用什么命令对什么修改权限?
如果是用其他的用户需要设置权限先
grant ....
具体命令查mysql
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/eM3000</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>307827</password>
</local-tx-datasource>
</datasources>
我用root登录还是不行
Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification message
from server: "Access denied for user: 'root@SHEN' (Using password: YES)")
这样设置的用户名:shen和密码:123,用程序调用还是不性
出现同样的问题
IDENTIFIED BY 'something' WITH GRANT OPTION;mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;