Hi folks,
I want to start programming in AMP. I have installed Mysql
-bash-2.05b$ mysql -V mysql Ver 14.5 Distrib 4.1.2-alpha, for pc-linux (i686)
I get the following errors when trying to access mysql.
---------------------- [root@andromeda root]# mysqld 040623 7:54:26 Warning: Asked for 196608 thread stack, but got 126976 040623 7:54:26 Can't start server: Bind on TCP/IP port: Address already in use 040623 7:54:26 Do you already have another mysqld server running on port: 3306 ? 040623 7:54:26 Aborting
040623 7:54:26 mysqld: Shutdown Complete ----------------------- [root@andromeda root]# mysql ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: NO) ----------------------- [root@andromeda root]# su - mysql -bash-2.05b$ mysql ERROR 1045 (28000): Access denied for user: 'thinrhino'@'localhost' (Using password: NO) -bash-2.05b$ ------------------------
Regards Aditya
On Wed, Jun 23, 2004 at 08:02:01AM +0530, Aditya Laghate wrote:
[root@andromeda root]# mysqld 040623 7:54:26 Warning: Asked for 196608 thread stack, but got 126976 040623 7:54:26 Can't start server: Bind on TCP/IP port: Address already in use 040623 7:54:26 Do you already have another mysqld server running on port: 3306 ? 040623 7:54:26 Aborting
040623 7:54:26 mysqld: Shutdown Complete
No need to start mysqld from the command line ... the init scripts are already doing that for you.
[root@andromeda root]# mysql ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: NO)
[root@andromeda root]# su - mysql -bash-2.05b$ mysql ERROR 1045 (28000): Access denied for user: 'thinrhino'@'localhost' (Using password: NO)
Read the manual. Get the HTML version ... its got proper tutes on how to create users, how to authenticate, grant privileges etc.
Sameer.