Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can I go about changing the root mysql password for WFA?
I think I know how to change it, I'm just not sure how to tell WFA what the new password is so things don't break upon changing it.
The only place I've seen to enter that password is during the initial install process.
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can start mysql using an init file.
#
# create admin user
#
# mysql-init.txt
#
CREATE USER 'root'@'%' IDENTIFIED BY 'admin123';
CREATE USER 'root'@'localhost' IDENTIFIED BY 'admin123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
and start mysql using this file
mysqld --init-file="mysql-init.txt" --console
Marcus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for this. But will WFA itself know about this password change and still be able to access the database?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I've never tried changing the mysql root password after installation. However, I believe the WFA server gets the mysql root password on startup through the registry (at least if you're on Windows), have a look in
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Apache Software Foundation\Procrun 2.0\NA_WFA_SRV\Parameters\Java
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
during installation a random password is generated and written into mysql and a jboss config file.
That's how WFA accesses the database.
Marcus
