Error 1044: Access denied for user ''@'%' to database
Posted: 08. April 2005 08:52
Hi,
I hope someone can help me , I came up with the following error when I tried to create a database from the SQl command line;
mysql> CREATE DATABASE VWorks;
ERROR 1044 (42000): Access denied for user ''@'%' to database 'vworks'
Can someone please explain to me why this is happening? I saw the solution given to another user which was to use PHPMyADmin, but I am doing some tutorials and I really would like to work from the command line.
I hope someone can help me out, before I bang my head on the wall. If it's not one thing it's another, yesterday it was getting InnoDB tables to register, the day before it was getting MYSQL to run. Will I ever be able to get on with what I want to do?
Please help!!!!!!!!
Also can anyone tell me why I would get the error:
"(OS 10038)Socket operation on non-socket: make
_sock: for address 0.0.0.0:443, apr_socket_opt_set: (SO_KEEPALIVE)
no listening sockets available, shutting down"
I have been getting this error every time I try to restart Xampp without shutting down my pc first. I have gotten round this problem by restarting my PC before I start Xampp, but it's not really on is it??? I have no othe webservers on my system, so what's going on?
Any help with this little problem would also be greatly appreciated.
Thanks in advance
Temisa
I hope someone can help me , I came up with the following error when I tried to create a database from the SQl command line;
mysql> CREATE DATABASE VWorks;
ERROR 1044 (42000): Access denied for user ''@'%' to database 'vworks'
Can someone please explain to me why this is happening? I saw the solution given to another user which was to use PHPMyADmin, but I am doing some tutorials and I really would like to work from the command line.
I hope someone can help me out, before I bang my head on the wall. If it's not one thing it's another, yesterday it was getting InnoDB tables to register, the day before it was getting MYSQL to run. Will I ever be able to get on with what I want to do?
Please help!!!!!!!!
Also can anyone tell me why I would get the error:
"(OS 10038)Socket operation on non-socket: make
_sock: for address 0.0.0.0:443, apr_socket_opt_set: (SO_KEEPALIVE)
no listening sockets available, shutting down"
I have been getting this error every time I try to restart Xampp without shutting down my pc first. I have gotten round this problem by restarting my PC before I start Xampp, but it's not really on is it??? I have no othe webservers on my system, so what's going on?
Any help with this little problem would also be greatly appreciated.
Thanks in advance
Temisa